LStylz
Have you tried using the combo box or list box wizard?
Add an unbound combo box...
- Click on the combo box button from the toolbar, and place the combo box on the form.
- Select "Find a record on my form based on the value I select..."
- Select the field in question that you want to pick from
- Sample data is displayed. The "Hide key column" is usually selected. (Access will actually add the primary key as well as the field you selected)
- Provide a suitable descriptive lable
This will work provided you use a suitable link field.
A little more detail...
As mentioned, Access will add the primary field to the "search process". The primary field is key to the search process, and is the "bound column". For example, for your contact database, Access will use something like this if you selected the Last and First names of the contacts...[tt]
SELECT ContactID, LastName, FirstName From...[/tt]
Richard