How to create s simple Find Form

[rtcary]

I am in the process of moving parts of an Apache, PHP, MySQL application to Access so others can modify it without knowing MySQl and PHP. My experience using the "programming" features of Access is quite limited, so forgive me if my question(s) are on the simplistic side.

My first goal is to create a few simple forms with the first being a Find one; one that will do a search for a Business Name (containing a string) against a Query. The results would be displayed in a grid/table view. I have the relational tables in place as well as queries that join them.



Not that fancy -- just plain-jane. Are there some easy help examples?

Many thanks...

Todd

[CJ_London]

look to the bottom of the thread - a couple of examples there. Otherwise set your query up as something like

SELECT *
FROM myTable
WHERE ClientName=forms!findformname!txtClientName OR ClientID=forms!findformname!txtClientID

in the query builder you can use the expression builder to navigate to the correct form and control for the bits in italics

Then in your find entries control onclick event put

docmd.openquery "myquerynamehere"

[rtcary]

Thank you! I'll play around with that, though I may have questions about the Form creating part.

Todd

[ssanfu]

Allen Browne has an example of creating a search form
http://www.allenbrowne.com/ser-62.html

There is a link to a database and has a link to the code.