copy 3 fields on form from 1 table in qry to the other table

[ImJay]

I have a large table with nine consecutive access forms: Requestor, Scope Review and 7 different approval forms. The table must contain Requestor's name, dept, Ext and Pager.

My requestors want automatic population of dept, ext and pager. There are 586 possible requestors so "dept", "ext" and "pager" are from the "NamesSite" table indexed to the "InputTable" by "requestor" on query "qryInputTableA" for "InputForm".

I have not been able to populate the "dept", "ext" and "pager" fields in the "InputTable". DLookup on the table, on the query, on the form or the fields of the form didn't work. InsertInto didn't work. CopyTo doesn't seem to exist.

Does anyone out there know how I should proceed?

Thanks,
Imjay

 

[PHV]

One common way is to have a ComboBox for picking the Requestor and then play with the Column property to populate the derived controls.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[ImJay]

PHV

Thanks for your reply. I was using a combo box initially. What I needed was some way to send the other three fields to the "InputTable". I did find a fix through a question posed for inserting the results of four combo box selections into a table. I adapted it to my problem and "UPDATE AS A SET" works beautifully.

Imjay