Create One Record in a New Table from several tables

D

DF2008

I have 4 "master" tables of information - Agent, City, Dept, and Level. I
have a form that has a list box for each field in each of the 4 tables [4
fields total].

What I need is: The User clicks to select the field information needed in
each of the 4 tables, then I want them to hit a command button and it creates
a new record in another table with the selected information.

Can anyone help me?

Would greatly appreciate it!
 
J

John W. Vinson

I have 4 "master" tables of information - Agent, City, Dept, and Level. I
have a form that has a list box for each field in each of the 4 tables [4
fields total].

What I need is: The User clicks to select the field information needed in
each of the 4 tables, then I want them to hit a command button and it creates
a new record in another table with the selected information.
Click to expand...

It sounds like you may be working backwards! The tables come first; the form
is just a tool to enter data into the tables.

Base your Form on the table which is to contain the data; set each listbox's
RowSource to the appropriate master table, and its Control Source to the field
into which that value should be stored. No code and no button needed - Access
will create the new record with the selected values as soon as you move off
the record.

John W. Vinson [MVP]
 
Top