Checking for a match

J

JoeP

When I enter a customer's first name and last name into a form (frmCustomer)
I would like Access to check to see if there is already a match for that same
first name and last name in the underlying table (tblCustomer).
If there is a match I would like a pop-up window to appear warning of the
match.
What would the code be to do this checking?
Thanks for any help.
JoeP
 
S

S Panja

One way is to set unique index on for a combination of these fields.
--
********* http://panjas.org
If the message was helpful to you, click Yes next to Was this post helpful
to you?
If the post answers your question, click Yes next to Did this post answer
the question?
 
J

JoeP

Thanks for the reply. How would I do that.

S Panja said:
One way is to set unique index on for a combination of these fields.
--
********* http://panjas.org
If the message was helpful to you, click Yes next to Was this post helpful
to you?
If the post answers your question, click Yes next to Did this post answer
the question?
Click to expand...
 
Top