Combobox looking for data in a table and write to another

[guangdew via AccessMonster.com]

I have two comboboxes on my forms. One is Gender that has values stored in
the Row Souce. This one works fine. I can scroll through record and select a
value (male of female), then it will be saved into the Employee table. I can
also scroll through records and it will display whatever saved value in the
table on the same combobox.

On my Order form, I have an Employee combobox which will find value from
Employee table. My question is how I can save the selected value into the
Order table?

Thanks to any response,

Guangdew

 

[John W. Vinson]

On my Order form, I have an Employee combobox which will find value from
Employee table. My question is how I can save the selected value into the
Order table?

Use the EmployeeID as the bound column and Control Source of the combo box (I
presume there is an EmployeeID field in the Order table?)

 

[Tom van Stiphout]

On Mon, 08 Feb 2010 21:26:20 GMT, "guangdew via AccessMonster.com"

Check out the Northwind sample application, Orders form (Order Details
in A2007). It has an example in the SalesRep field.

-Tom.
Microsoft Access MVP