By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,919 Members | 1,074 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,919 IT Pros & Developers. It's quick & easy.

How to import data from a form into another table?

P: 2
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_Accounts) 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_Accountsthat 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.

Jan 18 '11 #1
Share this Question
Share on Google+
1 Reply

P: 298
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
Jan 18 '11 #2

Post your reply

Sign in to post your reply or Sign up for a free account.