Getting an error on dlookup says cancelled previous opperation

G

Guest

I am getting this error and the statment below is the problem. SSN is text
also. Anyone have any ideas what is th eproblem with this?

You cancelled the previous opperation
DSM = DLookup("QLESQ_01", "QLESQ", "SSN = '" & SSNholder & "' And TodaysDate
= " & Format(Dateholder, "\#mm\/dd\/yyyy\#"))
 
D

Douglas J Steele

Are you sure that all of the field names are correct?

If you've mistyped something, you'll ofter get that misleading error
message.

If SSNholder and Dateholder are controls on your form/report, you might try
prefixing them with Me:

DSM = DLookup("QLESQ_01", "QLESQ", "SSN = '" & Me.SSNholder & "' And
TodaysDate
= " & Format(Me.Dateholder, "\#mm\/dd\/yyyy\#"))
 

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

Similar Threads

Dlookup error 13 7
Error: You cancelled the previous operation (No I didn't!) 1
DLookup Date Issues 2
Cancelled Previous Operation on DLookup or DCount 3
dlookup error 2001 1
dlookup problem 5
Dlookup Problem 2
Dlookup syntax error #3 Please :-))) 6

Top