Combo Box

  • Thread starter Thread starter Pass-the-Reality
  • Start date Start date
P

Pass-the-Reality

Using the Control Toolbox, I added a combo box to my worksheet page. What
code will I need to add so that the options 1-12 can be selected from my box?
 
Pass-the-Reality -

You need to set the row source of the combo box to be the table or query
that has the options 1-12 in it. If you want this result stored in a field
on the table, then you must bind the combo box to the field in the form's
recordsource by selecting that field in the Control Source of the combo box.
 
In the rowsourcetype of your combo choose valuelist.
In the rowource type the values you want as follows:

1,2,3,4,5, etc..

or

1;2;3;4;5 etc. (depending on the languagesettings of your pc)

Don't forget to set a controlsource field because otherwise the user can
select a value but that value won't be written to the database if you
designate a field to it.

hth
 
It would be easier to just delete that combo, put in a new one and tell
Access that you will type the values in (making the combo a value list.) Then
type your 12 values in and tell it what field in the table or query you want
it to save the value in.
 
Back
Top