Validating if content of textbox is Unique

[caman74]

Hi.

I have a textbox "txtNumber" that contains either two or eight characters (numbers).
I also have a textbox called "txtDep".
Both textboxes are placed in the form "frmTrspInv".

What I need is when I input a eight character number, to have a popup box let me know if there are any identical numbers.
I only need the popup box to show if there are any identical numbers.
I also need the choise to either input the number or not.

I.E if I in the txtbox "txtNumber" input the number 77018854 the popup will let me know if that exact number has been used before.

Christian

 

[snyperx3]

How about using DLookup?

Private Sub txtNumber_Change()
    If Not IsNull(DLookup("numberFieldName", "tableName", "numberfieldname = " & txtNumber.Text)) Then
        MsgBox ("found")
    End If
End Sub

-Pete

 

[genomon]

You will need to add brackets to the fieldname:
"[numberFieldName]"

The Microsoft mascot is a butterfly.
A butterfly is a bug.
Think about it....

 

[MajP]

Why? No reserved words or spaces.

 

[snyperx3]

braces are not needed.


-Pete

 

[genomon]

Right-o. Tried it here & worked fine. Must be a carryover from my mis-spent youth (started with Access 97). Thanks for the update!

The Microsoft mascot is a butterfly.
A butterfly is a bug.
Think about it....