I have just started to program in Access 2003 and want to use some of the VB Tools.
I have a field where the user enters a number, say 1234567-8.
I want the database to check that, the number has not been previously entered.
If it has, I want the program to return a message to the user saying ”Duplicate Voucher – Please check”.
I want to code the On Exit command of the field property. Can you suggest the correct code to use?
The field name is receipt.
Thanks
I have a field where the user enters a number, say 1234567-8.
I want the database to check that, the number has not been previously entered.
If it has, I want the program to return a message to the user saying ”Duplicate Voucher – Please check”.
I want to code the On Exit command of the field property. Can you suggest the correct code to use?
The field name is receipt.
Thanks