Find Out If Record Exits

  • Thread starter Thread starter Ben
  • Start date Start date
B

Ben

Hi Everyone,

How do I search a record to see if it exists. I have two
text boxes:

First Name
Last Name

When a user enter the information into the textboxes. The
textbox will check to see if this user exits. If it
exits, a mesage box will prompt the user.

Thanks,

Ben
 
Ben said:
Hi Everyone,

How do I search a record to see if it exists. I have two
text boxes:

First Name
Last Name

When a user enter the information into the textboxes. The
textbox will check to see if this user exits. If it
exits, a mesage box will prompt the user.
Click to expand...

Probably the easiest way is to use a combo box to search. There's a fair
chance that you'll have more than one last name the same and a very good one
that you'll have a lot of first names the same.

You can see the names and decide or use OnChange to decide when the name
does not exist.

I would try to teach the users what to look for when entering the search
string so they can apply the knowledge to all combo boxes.
Less chargeable time in the short run but they remember and tell their
friends.
 
Back
Top