Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Searches in a Form

Status
Not open for further replies.

Jengo

Programmer
Apr 17, 2000
100
US
How can I do a search for certain text in a field in a form.  Then get all of the files that comply with the search into a subform, so I can select which record I want to go to.
 
Easiest Way is make a query and base your subform on that query. Suppose that you have a key field called CustID.<br>Your query has this field in it as well as others that you want on your subform.<br>In the query in the CustID field have the &quot;Criteria&quot; be the CustID search box on the main form.<br>Have a command button that when pressed re-queries the subform.<br> <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top