Search box on form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to create a search box on my form. The table I am pulling the
data from contains the emp ID, name, etc. The problem I am having is
changing the combo to pull last name and first name instead of the emp ID. I
can barely call myself an intermediate user, so I would appreciate as much
detail as possible. Thanks in advance.
 
The 'empID' should be the first column with its width set to 0"

Your combo's rowsource should look something like:
SELECT [emp ID], [emp Lname]
FROM MyTable

Column Count = 2
Bound Column = 1
Column Widths = 0"; 1"

HTH,
Brian
 
Back
Top