Won't work with Alpha/Numeric value

H

Hookfoot

Does anyone know why this won't work with alpha/numeric values? It will work
with integers.

Private Sub txtID_BeforeUpdate(Cancel as Integer)
If Not IsNull(DLookUp("[ID]", "
", "[ID] = " & Me!txtID)) Then
Cancel = True
MsgBox "This ID already loaded", vbOKOnly
End If
End Sub

Any help is appreciated.

Hookfoot
 
K

Ken Snell [MVP]

You must delimit text strings with ' characters:

If Not IsNull(DLookUp("[ID]", "
", "[ID] = '" & Me!txtID & "'")) 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

Similar Threads

Access How to check that the value of a field in a new record is not present in 2 fields of the table? 0
Prevent Duplicate ID, Then go to the record that has that ID 4
Prevent duplicates based on two criteria 0
Code Duplicate problem 1
My code not work ===> Case vbNo 9
Edited data record to be inserted as a new data record under the same PO number in Microsoft Access 0
Problem with Before update 2
Help with Catching Duplicate Before Update 2

Top