>>I want to design a query but I want to pass parameters to the query to be used as a filter.
>>
>>The parameters will be passed from an open form.
>>
>>How can this be done ?
>>
>>Anthony Griffith
>
>Create parameterized local view.
I have used different groups of buttons in the forms to provide the user the selection of the parameters to be selected.
Then, using a button to "prepare report (sql)" I incorporate the selections into the sql by code in the .click method
Hope this helps you!
Art Castro