Populating a combo box w/o a table

[Guest]

Hi all,

I've been setting up combo boxes and using a simple table as the record
source where I would enter in the text I want as well as a corresponding
"order" number so the dropdowns would be sorted the way I want. Is it
possible to just enter in the choices I want in the order I want without
having to make up a table?

TIA

Aaron G
Philadelphia, PA

 

[Douglas J Steele]

If you're using Access 2002 or 2003, you can use the AddItem method.

If you're using an earlier version, set the RowSourceType property to
ValueList, and set the RowSource to a string containing the list of values,
separated by a semi-colon.

 

[Guest]

Doug,

AddItem looks like it's going to work nicely. Thanks for your help.

Aaron G
Philadelphia, PA