Help with Warning Message

[Adam McReynolds]

I need a field in an appendable query to show a warning message when duplicate data is entered. If it is not possible in a query then a form is fine. The table is Repairs and the field is Barcode. I do not want to prevent duplicates but only give a warning message to check the warranty. Also, I could use good directions on where to place the code. Any help is much appreciated.

 

[John Big Booty]

Welcome to the forums

Tables are where your data is stored and your user should have not direct access to this data. Queries are used to sort and collect the data for presentation in either a Form or Report.

All user interaction with you data should happen through the "filter" of a form. In this way you can control how you user views and interacts with that data.

In your case you could use the DCount() function, to check if data already exists, in the Form's Before Update event.

 

[Adam McReynolds]

Thanks for the help. I made a datasheet form of the original table and was able to put my code into the event and make it work.