I have a database that I have been battling with for a few weeks. The task seems easy but, I need some help.
I have a database that I need to be able to search by customers phone numbers. Which a can do now by setting my criteria.
So now, I have my data on the screen, filtered by the phone numbers... but now I need to be able to click the customer I choose to be able to open their record to enter data in the form.
Sounds easy enough, but i am stumped....
Oh yea, here is the kicker.... after I query my data by phone number, I really would only like to open that record with the name, number, and company fields already populated for me.
I am really hoping that someone on here can help me with this task. If anyone has a working database that has an example of this, please let me know.
Any help is appreciated !!