ADD CHOICES TO DROPDOWN LIST MENU

[Guest]

Hi I am trying to create a form in Access 2003 that will allow me to enter
survey results. I am stuck, I need to know how to add the choices to a
dropdown list menu.

 

[Guest]

Hi Meka,

The best way would be to have your combo box get its data from a query of a
table containing items. That way, if you need another item to select from,
you simply need to add it into the table. eg:

select ItemID, ItemName from tblItem order by ItemName

Hope this helps.

Damian.

 

[Guest]

Ok, I'm still not sure what to do? Are you saying I need to create a table
and store data there first? Then tell the form to retreive it from there?

 

[Guest]

Yes, if you want to give a user a list of choices in a combo box, it either
is a list that you type into the box, or it gets its list from a table. I
say use a table, because then to add an item to the list, you simply put
another entry in the table.

Create a table eg: tblItem (give it a meaningful name). Have two fields -
ItemID (autonumber) and ItemName (text). Enter the details of each item into
the ItemName field, then on your form, add a combo box. When it asks where
to get the data from, select tblItem (the table you just created).

In your main table, you need to have a number field that links to the
ItemID in table tblItem - this is the field that is bound to your combo box.
The users see the ItemName, but the data that is stored is the ItemID, hence
if the name changes this is reflected across your database.

Hope this helps.

Damian.