Access 2010 Dlookup problem

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
 
Back
Top