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

Combo Box in Form (2 Tables used)

P: 5
I have an Employees tbl, and then a 2nd table needs to be populated. Half data is from Employee tble, other half data entry.

I have a form that will populate the 2nd table. The ID combo box I get to pull up the ID# from the employee table, now I can't figure out what kind of event procedure for "After Update" to write to get the associated records to pull up data for the "name" "ssn" "position" etc. fields to auto fill for the next record for saving on the 2nd table. Hopefully I explained this ok.
Thanks for any help.
Jul 24 '06 #1
Share this Question
Share on Google+
2 Replies


100+
P: 179
I can't really understand your problem. Might need more detail.

Is the second table being populated with data from the first table? If so, how are you doing it? Are the 2 tables linked?

Also, is it possible to get some code?

comteck
Jul 25 '06 #2

P: 5
I'd like the 2nd table to be populated from SOME data from 1st table and rest with entered info.
Right now I'm not doing it in any way.
To let you know where I'm starting from I'm converting the database of an old piece of software called Professional Files (dos based).
It uses "LOOKUP" statements in it to pull info from one table to add records to another table (or db).
Jul 26 '06 #3

Post your reply

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