Can someone Please tell me what is wrong with this statement?
DLookup("[AssignedEmployee]", "[ShippedEmployees]", "[Vessel]= '" & Combo5 & "' AND [Position]= '" & Combo7)
Thanks
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 & "'")
Thank you Toyman!!!
I had Tried the "'" at the end, but without the &.