If a value already exists

R

Ryan

I have a form "BatchTracking" with a field [FileName]. What I would like to
happen is when I put in a value that already exists, to have my own message
box show up with what I tell it to say, instead of microsofts default message
box. Is this possible?
 
R

Ryan

Thank you very much, that is exactly what I was looking for.

Ofer Cohen said:
Check this link on "Preventing Duplicates from being entered - Database
Solutions for Microsoft Access"

http://www.databasedev.co.uk/duplicates.html
--
Good Luck
BS"D


Ryan said:
I have a form "BatchTracking" with a field [FileName]. What I would like to
happen is when I put in a value that already exists, to have my own message
box show up with what I tell it to say, instead of microsofts default message
box. Is this possible?
Click to expand...
Click to expand...
 
Top