dlookup issue

[Gina Maylone]

Hello!

I am attempting to lookup the date an employee attended a training event, from within a subform. Main form: Employees, Subform: EmployeesRequiredTraining, Query where I'm trying to get data from:EMPLOYEEATTENDANCE. My lookup statement:

=DLookUp("eventdate","EMPLOYEEATTENDANCE","[EmployeeID] & "=[Forms]![Employees]![EmployeeID]) And ([EventID]=[EventID])

. It returns blank. At one point it returned -1, and another point 12/1/1899. Can't remember what I had changed to get those.



What am I missing? TIA!

P.S. Not sure if it matters, the form I'm trying to lookup from is a continuous form.

[June7]

The & and = signs are in each other's position, extra parens, and also need to concatenate the EventID phrase.

=DLookUp("eventdate","EmployeeAttendance","[EmployeeID] = " & [Forms]![Employees]![EmployeeID] & " And [EventID]=" & [EventID])

If there is no match will return Null.

Suggest you not use ALLCAPS in naming convention. It is harder to read.

[Gina Maylone]

The & and = signs are in each other's position, extra parens, and also need to concatenate the EventID phrase.

=DLookUp("eventdate","EmployeeAttendance","[EmployeeID] = " & [Forms]![Employees]![EmployeeID] & " And [EventID]=" & [EventID])

If there is no match will return Null.

Suggest you not use ALLCAPS in naming convention. It is harder to read.

THANK YOU JUNE! Worked perfectly! Have an awesome day!