Telephone number checking existence

I have a field called Telephone and when entering a telephone number I wish to check if it already exists in the table. If it does then a message is displayed alerting the user and allowing the user to accept the number or delete it
but if it doesn't then the phone number is accepted (automatically)

The process is essentially

1. the user moves into the telephone number box
2. the user types in a phone number
3. a check occurs to see if the number exists

and then ideally

4. you want it to search for the phone number and if it finds it to display a message, which asks for user input 5. but if not it accepts the phone number is accepted in the box

steps 1 to 3 are OK and I know I about the OnBeforeUpDate property

but I'm not aware how to enter the phone number and then check it and close anything executed as part of this validation.

Ideas most welcome.

Peter
prmitch_at_camtech.net.au Received on Thu Jan 13 2000 - 00:00:00 CET