showing criteria on report from multiselect lstbox on form

[MR_G]

Hello again everyone,

Here is the situation:
******************************************************
Form_Filter has lstbox lstCriteria1 and is multiselect (simple)

when users pick their chosen criteria, I want to have a listbox on Report_1 that shows what they picked. and I want users to be able to have the Form_Filter and Report_1 open simultaneously.

Sounds simple enough, but no luck so far.

Any suggestions?

(ps- the form / filter work fine, its just a problem with showing the criteria)

 

[pbaldy]

One way would be to pass the chosen options to the report in the OpenArgs argument (versions after 2000 IIRC), then assign that value to a textbox in code in the report. It might help to know how you open the report from the form (and what Access version).

 

[boblarson]

You can put a text box on the report and as long as the form is still open when the report opens it can display the form's filter.

Put the text box on the report (header or footer probably) and set the control source to something like this (changing the names to the applicable names in your db):

=Forms!YourFormNameHere.Filter