Checking for a match

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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?
 
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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Partially match 2 lists 1
avoid duplicate record. 1
Name searching problem 2
Excel [VBA] Check from a cell into another sheet and bring back result in MsgBox 0
Look up in DB 3
Query that seeks to match all records b/w two tables by either SocialSec # or Name 5
Excel ALERT a duplicate of the match of two cells in two different columns... please 0
Excel Is this possible?? 3

Back
Top