Help me to create search button

sultan_abang

New member
Local time
Today, 19:54
Joined
Oct 27, 2012
Messages
8
hi!
i'm beginner in access, please help me to create search button. i make form & in that form i give a text box. my wish, when I type a some name in the textbox, then I press that searchbutton, then the form will immediately directly the name in the query.
Please.....
 

Attachments

I put a combo box on the form that you can use to select a name,
after selection the record contents will be displayed.
Look at the code in the After Update Event to see how it works.

In your table one of your fields is called 'Name' which is a reserved
word in Access. Using it may cause problems down the line.
I changed it to: CustName.

Good luck.

Catalina
 

Attachments

@catalina

thanks for ur help, but i wish, i can make a searchbutton. the mean when i'm type some name in textbox form & i click find customer button, then he can directly display the name in a query, such as an example in link. I've tried, but I don't understand why it doesn't work.

please help me....
 
hi!
i'm beginner in access, please help me to create search button. i make form & in that form i give a text box. my wish, when I type a some name in the textbox, then I press that searchbutton, then the form will immediately directly the name in the query. the mean when i'm type some name in textbox form & i click find customer button, then he can directly display the name in a query, such as an example in link i attach. I've tried, but I don't understand why it doesn't work.
Please help me.....
 

Attachments

Last edited:
Look at "DemoFindA2002.mdb" (attachment, zip).
Open form and try.
 

Attachments

... and the answer provided in the other thread was;

You need to change the name of your form to; searchform to match what the query is looking for, or change criteria in your query to look for a form called Mainform
 

Users who are viewing this thread

Back
Top Bottom