Creating Drop-down List in the Design View

[Ter Bai]

I am creating a new database in Access 2000, and I cannot figure out how to
create a drop-down list box. I already set up my Validation Rules (I used
the In("","") format) and Validation Text, but apparently that isn't enough.
I also selected "list box" under the Lookup table, but I can't see my list in
the Table View. Please advise.

 

[dl]

What I've done is create a small table with the selections you want to show
up in the drop down, give it a name that reflects it's purpose (i.e.
tbl_drpDwn_NAME).

Now go to your form in design view and input a Combo Box, not a list box.
The wizard will walk you thru it and ask if you'd like the selection that
someone chooses to be placed into the cell of a main table or held for other
operations.

hope that helps!