Validation/Message

[Guest]

I'm fairly new to Access programming and have a question.

My form needs to check for the presence of the data entered by the user in
another table and if it is not there, make a message visible on the form.
The focus needs to return to the field and clear out what was entered and
basically start over. The message that was made visible needs to disappear
after a delay.

The field is called VIN and is in a table called tblInspData. The table
that it needs to reference is called tblVINs. The message on the form is
labeled BadScanMsg. BadScanMsg would only become visible if a VIN was
entered in the VIN field that was not in tblVINs.

Any help would be appreciated.

 

[Guest]

Have a look at this link

http://www.databasedev.co.uk/duplicates.html

It gives an example on how to search for duplicate, for your need, change
the IF criteria from > 0 To = 0