If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Combobox looking for data in a table and write to another
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] |
#3
|
|||
|
|||
Combobox looking for data in a table and write to another
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 |
Thread Tools | |
Display Modes | |
|
|