Combobox looking for data in a table and write to another

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

--
Message posted via http://www.accessmonster.com

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

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?)
--

John W. Vinson [MVP]

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

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

-Tom.
Microsoft Access MVP


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