I'm using:
DLookUp("[STRField1]","[Table1]","[NumField1]='" & [NumField1] & "' AND [NumField2] ='" & [NumField2]& "'") with no issues
I am trying to add:
[NumField3] = 1 - I keep getting data error
DLookUp("[STRField1]","[Table1]","[NumField1]='" & [NumField1] & "' AND [NumField2] ='" & [NumField2] & "' And[NumField3] =1'")
Its this part=1'" where I am screwing up
Thanks