File 1 has code field, file 2 has code and desc fields. I need to select via combo box a description field and update the code field in File 1 based on that selection. How is the lookup table bound to the master? Link by code is already set up via data environment. I am confused by combo box properties.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
combo box bound to a text box 1
- Thread starter LenaS
- Start date
-
1
- #2
ChrisRChamberlain
Programmer
LenaS
Set the .ControlSource of the ComboBox to TABLE1.field, that is the field you wish to update.
Set the .RowSource of the ComboBox to the TABLE2.field, that is the field that you want to supply the data.
Set the .RowSourceType of the ComboBox to 6 - Fields
You do not need a relationship between the two tables
Hope this helps.
Chris
Set the .ControlSource of the ComboBox to TABLE1.field, that is the field you wish to update.
Set the .RowSource of the ComboBox to the TABLE2.field, that is the field that you want to supply the data.
Set the .RowSourceType of the ComboBox to 6 - Fields
You do not need a relationship between the two tables
Hope this helps.
Chris
- Thread starter
- #3
- Status
