Combo boxs and control sources

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a combo box that has 2 columns and it will save the 1st value into my
control source but how do I get it to save the 2nd value to a different
control source at the same time?

EX:

Combo Box control source 1 control
source 2
site A | 001 site A
001
site B | 002 site B
002


Thanks
 
Joel said:
I have a combo box that has 2 columns and it will save the 1st value into my
control source but how do I get it to save the 2nd value to a different
control source at the same time?

EX:

Combo Box control source 1 control
source 2
site A | 001 site A
001
site B | 002 site B
002


Thanks
Click to expand...


Well, obviously, if the combo box is unbound, nothing is automatically
saved. If the combo box is bound, the bound column is what is saved to a
field. To save other columns in a combox would require running an update
query or using code to save the other value(s).
 
Back
Top