Populating a combo box w/o a table

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

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
 
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.
 
Doug,

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

Aaron G
Philadelphia, PA
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cascading Dependant combo boxes 0
Populate combo box from current record 3
Combo Box 2
How to Populate Data from a table to another 0
Sort with Combo box 2
synchronizing 2 combo boxes on a form Pt2 1
Linking forms to tables 3
Combo Box selection / AUTO POPULATE subsequent text boxes 8

Back
Top