Validating Field Entry

[123James]

Hi everyone

I have a table with the following fields: entry ID, surname, forename, date

I have created a form based on the table where data can be entered but I don't want people to be able to enter a combination of surname, forename and date that already exists in the table.

How can I create a validation that will flash up a message after the date text box has been updated warning the user to change the date if an entry with the same surname, forename and date entry already exists?

Thanks
James

 

[rainman89]

you would probably have to have a dlookup and a dcount combo to get that working for u

here is a good lookup helper

and lookup dcount

 

[gemma-the-husky]

it starts getting tricky, because if the users don't enter name surname date in correct order, the tests wont work properly - so you may need this test after each of name surname date

you would also have to test again on change of name surname date

i have done stuff like this, by making every control grayed UNTIL you have a valid selection.

 

[123James]

Thanks for the advice but this is sounding far too complicated for me!!

I was hoping there was a simpler way of doing this maybe by using the expression builder or something. If not I will have to give it a miss im afraid...

Thanks
James