[RESOLVED] VBA and Access Database integration..help pls..??

[zach007]

Dear Experts,

I am trying to make a VBA program from a "word document" that can collect information/data from Ms Access database...my question is:

There are : Item Code , Descriptions, Qty, Unit Price and Total (all as TextBoxs except Item Code as a drop down menu)...what I am trying to do is, when I select Item Code from the drop down menu, it will collect all information (Description, Qty, Unit Price) and write into each TextBoxs and also it will calculate automatically for Total and write the total into the TextBox...

Anyone could help me please..please..???

Herewith, I attached a sample/dummy as a ZIP file for your reviews...and for my self learning...dont worry about other codes (such as how to write into the word documents, how to pop up, etc)....what I am trying to do is just how to make those codes run well....

Thank you very much for your kind attention and helps.

Best Regards,

Jennifer