Forms

[Chantelle Wynn]

I need to have a field on a form with an auto number e.g. 1,2, 3 and then
link this so that when you select e.g, 1 it brings up a persons first and
last name how do i do this?

 

[Sprinks]

Chantelle,

If the control is bound to an AutoNumber field, it will be automatically
assigned, so I'm guessing that what you're trying to do enter a foreign key
from another table which identifies a particular person. If so, include the
name in the RowSource of the combo box, set the BoundColumn to 1, and set the
ColumnWidths to 0";x", where x is wide enough to display the longest name.
This will display the name yet store the foreign key.

The RowSource will be something like:

SELECT YourTable.ID, YourTable.FName & " " & YourTable.LName AS FullName
ORDER BY FullName;

Hope that helps.
Sprinks