trying to see if a value exist in a record

[gcrutch]

I have an access form that allow users to enter some data. for instance, they will enter a FileNo, date, FileName, etc. When they enter the file no I want vba code to see if that file no has already been used. If it has been used send a message back to the user that it has already been used and set the focus back to the FileNo text box so that they can enter another file no. This is not the primary key. I just don't want the user to be able to use the same fileNo more than once.

 

[pbaldy]

You can use a DCount() to test the underlying table:

http://www.mvps.org/access/general/gen0018.htm

in the before update event, which let's you use Cancel = True to stop the update.

 

[gcrutch]

ok, how do i use DCount()

 

[pbaldy]

I've been out of the country. Hopefully you figured it out using the link I had provided?