S
Shanin
I was trying to make a query that used a form and the Dlookup to sort the data but am only getting blank results.
I had a form made with a dropdown box where staff could choose the employee they wanted and then hit the control button next to it to run the query and it would pull up all their training. I also had one so they could choose the department and it would list every employee that has trained in that department.
I'm only using "Name", and "Training" (Name from tblEmployees, Training from tblTraining) in this query and using this as the criteria under "Name"
DLookUp("[Name]","[tblEmployees]","[Name] = '" & [Forms]![Train]![NameList] & "'")
My results keep coming back blank, or it will say it cannot understand the expression.
I had a form made with a dropdown box where staff could choose the employee they wanted and then hit the control button next to it to run the query and it would pull up all their training. I also had one so they could choose the department and it would list every employee that has trained in that department.
I'm only using "Name", and "Training" (Name from tblEmployees, Training from tblTraining) in this query and using this as the criteria under "Name"
DLookUp("[Name]","[tblEmployees]","[Name] = '" & [Forms]![Train]![NameList] & "'")
My results keep coming back blank, or it will say it cannot understand the expression.