Passing parameter from form to query

[rhubarb]

I have a form where the user selects a filter, then a combo box below that limits the results to said filter. Say the filter is employees, my (lstTicketFilter) filter combo box below will drop-down and show all employee names.


That works fine. When I select the preview button to open my report for this filter it asks for a parameter lstTicketFilter, despite it being selected in the form.

So I open my report, and the record source is my query which pulls all corresponding date to the employee name. If I remove the record source query and replace it with the contents of the same query the report pulls fine.

Another question would be does it matter if I keep my query contents (some of it is very long) in the record source of my report? Is there an argument to just replace it with a query? I feel like the latter is cleaner but why isn't my form passing the query the parameter selected in the form?


Thanks for any help!

[ItsMe]

...Is there an argument to just replace it with a query?...

Use the name of your query object in the Record Source property of your report. Use the pulldown to select the correct Object Name. It may be easier to edit a Query Object vs. editing the SQL syntax within the RecordSource property field.

It appears your SQL that is in your Report's RecordSource has incorrect syntax. Perhaps the form name defined within the SQL is misspelled.

Also, make sure you are using a combo and not a multiselect listbox for your parameterized query. Applying the values from a multiselect listbox takes a little bit of effort.

[rhubarb]

I resolved. My WHERE clause reference to report had typo! This caused the parameter prompt. Thanks for the help!

[ItsMe]

You bet. Glad you sorted things out and posted your solution.