Passing parameters to a query

[stephenaa5]

Good day. I have a query that successfully feeds a MapPoint dataset. There is a button that opens the Mappoint map. I need to filter that query using the button that launches the map (just prior to launch, of course), and am unsure how to do it.



My user has an interface on a CONTINUOUS form named DashboardFrm. On that form is a text box named ClientSite1 which is what I want to filter based on, for the chosen record on the continuous form. The query being run is "SinglePointMapQry." Each record has a button labeled "map," which is command10.

So the condensed version is: Pushing the command10 button should pass the value in ClientSite1 to SinglePointMapQry, and then launch c:\singlepointmap.pmt.

Suggestions? It seems like it should be easy, and I'm making it hard.

Thank you!

Stephen.

[pbaldy]

The simplest way would be to have a criteria in the query:

Forms!DashboardFrm.ClientSite1

Since you'll be pushing a button in a particular record, that record would be the one used by the query.

[stephenaa5]

I knew I had to be missing something obvious.

Much appreciated!

SC

[pbaldy]

Happy to help!