Lookup

[Denise]

I have a form that I use for entering in the various
training that employees have completed. I want to search
for the employee by last name from the employees table and
display some of their information then enter in what
training they have had and other details.....I created the
table and used the lookup wizard linking their Employee
numbers...but I don't know how to make their last name,
first name display on the form.

Thanks for your help,

Denise

 

[Dan Artuso]

Hi,
Usually you would display the names in a combo box.
The query that feeds the combo would be something like:

Select EmpId, LastName + ", " + FirstName AS FullName
FROM yourTable

Then in the properties for the combo:
columns: 2
column widths: 0";1"
bound column: 1

so the combo now displays the full name but you actually use the employee id to search.
How you do the search and display the results is entirely up to you.
If you simply want to select a value from the combo and have the form move to that record,
the combo wizard can help you out. Just choose the query for the combo's row source when prompted