Search results

Hi HTH After modifying as mentioned below, my code is as follows :- RightUser = DLookup("[UserRights]", "tblRights", "[FormName]='" & Me.name & " And [EmplUserName]='" & TempVars("EmplUserName") & "'") (Want to retrieve UerRights (numeric value) based on two criteria One is Form Name...

Hi everyone. Error while executing following code relating DLookup RightUser = DLookup("[UserRights]", "tblRights", "[FormName]=" & Me.name & " " & "And [EmplUserName]='" & TempVars(EmplUserName) & "'") this gives the error "Data type mismatch in criteria or expression". Any ideas? I'm...