Problem with report based on parameter query.

[Plumes]

Hi

I have a form and report based on a parameter query "qry_CRF". When I run the query a dialog box pops up asking "Which Client?" and the same happens when I open the form or report. I have a cmd button "cmd_Print_Report" on the form to print the report but when I use this it asks again for "Which Client?".

Is there anyway around this? Or will I have to create a form/subform?

Matt

 

[luceze]

In your query parameters you should see something like this
[Which Client?]

If you want it to refer to the current client that is selected on your form then you need to change it to
forms!YourFormName!YourClientFieldName

HTH,
Eric