Keyword Search button

[bday]

I have a report that spits our several fields from a query. How can I add a button on the switchboard that opens a dialog box and allows the user to type in a keyword and then opens the report for all records that contain the keyword anywhere within the entire query?

 

[jdraw]

Here is a link to tutorial on Dynamic Reporting. It uses dialog forms that may be of interest to you.

http://www.fontstuff.com/access/acctut19.htm


Here is a link to a video tutorial on Basic Search Form
http://www.datapigtechnologies.com/flashfiles/searchform.html

Both sites have great tutorials.