Access DlookUp not working with multiple Criteria

user_13970572 0
Viewed 50

The Dlookup Function is Giving me a syntax error I have tried multiple ways but none worked

x = DLookup("Clock_ID", "User_access", "Clock = " '" & Me.Clock_ID & _
         & " AND Module = '" & Me.m_1 & "'")

I basically Need it to check 2 fields in the same table at the same time so the ID can be duplicated But the Module cant be duplicated.

ms-access vba
1 Answers

I guess ID is numeric, so try:

x = DLookup("Clock_ID", "User_access", "Clock = " & Me.Clock_ID & " AND Module = '" & Me.m_1 & "'")
user_35272970
Related