Combo Box

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

 

[Daryl S]

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.

 

[Maurice]

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

 

[golfinray]

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.