- Joined
- Apr 18, 2016
- Messages
- 1
- Reaction score
- 0
I have code that is not working which is looking up an a number on a form. If the number matches the number on the form in a qry then it should perform an action. the number is a string the code is as follows:
Dim svarx as string
svarx = Me.spec_nbr.Value
ElseIf DLookup("SpecLong_nbr]", "qry_below", "[spec_nbr] = `" & svarx & "`") Then
Dim svarx as string
svarx = Me.spec_nbr.Value
ElseIf DLookup("SpecLong_nbr]", "qry_below", "[spec_nbr] = `" & svarx & "`") Then