How to have a dropdown list

[djossh]

Hi, I'm really new to Access, don't know how to do this...

scenario:

I need to enter a "Name" in my forms but i don't want to enter the ID# I want to have my form to show a dropdown list of the "Name" not the "ID# (primary key)...suggestions or sample file will be great.. THANKS!

Table1 fields:

ID#(Primary key)________Name
1____________________John Johnson
2____________________Michael Taylor
3____________________Carol Murray

 

[John Big Booty]

The sample posted here may give you some pointers.

 

[andrewsmith]

1. Create a combo box bound to the ID.
2. Set the row source type to Table/Query
3. Set the row source to SELECT ID, Name FROM table1 ORDER BY Name;
4. Set Bound column to 1
5. Set Column count to 2
6. Set the Column widths to 0cm,6cm (second width can be anything but first must be 0)