By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,652 Members | 1,905 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,652 IT Pros & Developers. It's quick & easy.

location search

lee123
100+
P: 556
hi there is there a way to make a search button or out of a text box to find a certain customer in a form instead of a customer list?
May 20 '07 #1
Share this Question
Share on Google+
2 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
You have posted this in the Articles section.

I am moving it to the Access forum.

ADMIN
May 20 '07 #2

P: 49
hi there is there a way to make a search button or out of a text box to find a certain customer in a form instead of a customer list?
YES!

Simple process without coding.make a form, name it "customer search" place as many text boxes on as is required i.e if its a name with FIRSTNAME (record) LASTNAME (record) then 2 will be enough. If a company then one will be enough - your choice.

Then name the text box through its proporties i.e. first_name, last_name

set up a query with all the details you want. In the CRITERIA place

LIKE(formname!textboxne) &"*" <~~ wild card if needed

Use the BUILDER to help construct

one done create a form based on the query

go back to the search form place a command button on to open the "query output form", the one that will be populated by your customer search query.
enter in to the text box(es) who you want to look for and click the command button theres a search

Gareth

"Keeping it simple for those who are new"
May 20 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.