How to import data from a form into another table?

[Scott Martinek]

I created a form (Base_Data_Form ) that updates a table (BaseDataTbl) and I created a combo box to populate the account number from a different table (0004_All_Accou nts) when the account number is selected.

The account number goes in the form and the table when selected from the combo box with no problem. There are about 10 other fields in table 0004_All_Accoun tsthat I would like updated in the Base_Data_Form and BaseDataTbl when the account number is selected. I can make the data appear in the form, but I can't get it to go to the table. I have tried using various events (Before Update, After Update, On Enter, On Exit, etc.), but I get an error message...

*** The expression on enter you entered as the event property setting produced the following error: The object doesn't contain the automation object*** every time.

I'm not against using Visual Basic, but I don't know it well enough to get through it on my own. I see where people use Me. in VB, but I have no idea what that means. This is not my first database, but it's the first DB I've created in several years so I'm a bit rusty and I would appreciate any help.

Thanks

[pod]

my best suggestion to you is to check out the design of a form that works.

download the northwind sample database
and copy what you need from it

http://www.microsoft.com/downloads/en/details.aspx?FamilyID=06616212-0356-46a0-8da2-eebc53a68034&displaylang=en