kiirowei
asked on
MS Access Search Function
Dear Experts:
I have a form name "customers", it have CusotmerID, CustomerName, BillingAddress ...
When I add a search function, it only search for CusotmerID, that's the primer key.
How can I change it to search other tables in the form? like search for CustomerName or Address?
Thank you.
I have a form name "customers", it have CusotmerID, CustomerName, BillingAddress ...
When I add a search function, it only search for CusotmerID, that's the primer key.
How can I change it to search other tables in the form? like search for CustomerName or Address?
Thank you.
ASKER
mbizup:
It works for other fields right now, all I have to do is select "csutomers search" from "Look In" drop down list.
Thank you for your help.
It works for other fields right now, all I have to do is select "csutomers search" from "Look In" drop down list.
Thank you for your help.
Hi kiirowei,
If I'm reading your last comment correctly, you've found a working answer for your question. If that is the case, you can post a note in Community Support asking them to close the question and refund the points.
If I'm reading your last comment correctly, you've found a working answer for your question. If that is the case, you can post a note in Community Support asking them to close the question and refund the points.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Please describe how you set up your search function.
>like search for CustomerName or Address?
Give Access's built-in search feature a try ---
Right click on the field you want to search in and select "filter For"
Specify your criteria in the text box. You can type your criteria exactly, or use wild cards.