Altering combo box? - Access 2003

[W E B G U R L]

I created a combo box in my form which I want to add to. How do I do this? Only via the
properties?


Thanks

 

[John Vinson]

I created a combo box in my form which I want to add to. How do I do this? Only via the
properties?


Thanks

That depends on how you set it up.

If you used a "List of Values" then yes; you can view the combo in
Form Design view, view its Properties, and see what the Row Source
Type is to find out.

If you want to be able to routinely add values, use the Table/Query
option instead, and set the Row Source to the name of the table. I'd
actually recommend having a Table with the values you want in the
combo; create a Query sorting that table by the field the user will
see; and use that Query as the rowsource. Then simply adding a row to
the table will insert it (properly alphabetized) into the combo.

John W. Vinson[MVP]