Using a Lookup form to search results in a Query

[Kattracks32]

I have a query that I need to pull an employee's attendance records from. I have all the fields that I need and I set up the parameter to search for specific employees based on a form [forms]![fmAttendanceLookup]![Name]. When the form is not open a box pops up and I can enter the name and it returns the results. When I use the combo box which has all the employee names in it and run the query it comes back with no results even though I know there are records associated with that name.

Since it works when I manually type the name in I am assuming that it is an issue with the combo box on the form and not the query itself.

I have two tables, one that has the employee info in and a separate one with all the attendance records. The relationship is a one-to-many with the EmployeeID as the foreign key that links the two tables.

Thanks in advance for any help with this issue


Kat

[Bob Fitz]

Perhaps the "bound" column of the combo box is not the "Name" column.
BTW: Name is a reserved word in Access and should not be used as the name of an object.