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 "Criteria" 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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.