Find Box

BenHarper

Registered User.
Local time
Today, 21:10
Joined
Jul 27, 2000
Messages
10
How would I go about creating a find/search window that 1) is not the built-in find tool, 2) asks the user to input only two fields: first name and last name (or just last name of the client), then calls up that record in the form. I find that the built-in find tool is very inconsistent, particularly when the last name appears a number of times in a record. It's also a pain to show the computer-illiterate here how to use it.
I would appreciate very much any help I receive.
Thanks in advance,
Ben
 
have the user input info into the two fields.
Then use dlookup in your vba code to find the records. You could also apply a filter after the info is input which would also find any records with that information
 
I probably should have mentioned that I am still a novice with Access, and so I might need a little more help than this. I understand the idea, but I don't know vba very well, so if you could give me an exmaple of the code to do this, I would very much appreciate it.
Thanks again,
Ben
 

Users who are viewing this thread

Back
Top Bottom