auto check field

[Angeliqur]

oke, let me explain a bit more
i have the next table
partsID discripsion (text field) orderparts (number field) supplaer
and more....
1 Cilinder 05120100
Schreinemacher ...........
2 Cilinder 05120101
Schreinemacher ...........
2 Valve 02156412
Schreinemacher ...........
etc...

now what i want is that when i fill in a new record de field orderparts
will be checkt at dubbel entry by access. On a form is this the first field
that i have to fill in, now if the nummer exists i want a messege or
something

this must then be dun after a update i think

I want this so that i do not type in the same orderpart in my table


many thanks in advance
Angelique

 

[Guest]

hi,
To do a quick check of double input i usually use DLookup.
here is an example of how i use it.

If (DLookup("[TAGUser2]", "TAG", "[TAGUser2] = '" & Me.txtBOMTAGID & "'"))
Then
MsgBox ("This BOM Tag has been used once. Check your
input .")
Exit Sub
end

Regards
FSt1