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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top