Drop down list

[PedX]

I have a table that contains a column called Category. This Category column will be populated by one of seven choices. Is there a way to make a drop down list that contains these seven options only?

I have very little knowledge of Access, so I apologize in advance if this question is rather pedestrian.

 

[bat17]

You use a ComboBox for this. Use the wizard to create it and it will give you the choice of taking the list from a table or entering it by hand.
A table is best because it is easier to update if the requrements change.

HTH

Peter

 

[Abulafia]

Actually, a query based on the table is the best option for a combobox's RowSource.

With a query you can sort the records and restrict any should you wish.

You shouldn't ever have cause to bind a table to anything.

 

[Norie]

Where do you want the combobox?

Is it on a form or in the actual table?