Check that entry does not exist

[msaunders26]

Hi Everyone,

I am completely new to Access, coming from the web development world, so though I know some concepts I am still clueless when it comes to this

I'm trying to build a form, but before the data is entered into my table I need to ensure that the entry doesn't already exist. Could someone please tell me how to do this? If it involves any code or SQL queries, please remind me where I should place it. Thanks!!!

 

[rolaaus]

How many fields are you trying to validate? If it is just one, then you can place some code into the controls (field) Before_Update that checks for the value entered.

Also, if you have multiple fields that make up a primary key, then you can trap the error that is produced when the form tries saving the data entered, then tell the user there is duplicate info and not save it.