I am making a database for a friend and I need to know how to get the first field (phone #) to query once information is entered into it.

I need to be able to enter the phone # and have it query the backside table in the phone # column to look for duplicates. If it finds one, I need an error message. If not, I need it to continue to the rest of the form (next field is LastShow).

Please help, and thanks in advance!

Matt

The combo box wizard has an option (#3) to select a previously existing record based on the value you type in. You might try making an unbound combo box and selecting that option, it may do what you want (I'm not sure phone number is a good unique value to choose, but that's up to your database design).

David R

[This message has been edited by David R (edited 01-22-2002).]