Dlookup help

[justhininabouti]

Can someone Please tell me what is wrong with this statement?



DLookup("[AssignedEmployee]", "[ShippedEmployees]", "[Vessel]= '" & Combo5 & "' AND [Position]= '" & Combo7)


Thanks

[Toyman]

Can someone Please tell me what is wrong with this statement?

DLookup("[AssignedEmployee]", "[ShippedEmployees]", "[Vessel]= '" & Combo5 & "' AND [Position]= '" & Combo7)


Thanks

You need the sigle quote at the end
DLookup("[AssignedEmployee]", "[ShippedEmployees]", "[Vessel]= '" & Combo5 & "' AND [Position]= '" & Combo7 & "'")

[justhininabouti]

Thank you Toyman!!!

I had Tried the "'" at the end, but without the &.