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"
556
