Open Report based on Values in Form

[rkm2]

I currently have a form "UserSearchForm" which allows a user to select values from several different unbound combo boxes in the header section and press a search command which filters the list in the detail section.

I want to be able to create a button which previes a LabelsReport based on the filtered list in the form. Any thoughts?

[Jim Doherty]

I currently have a form "UserSearchForm" which allows a user to select values from several different unbound combo boxes in the header section and press a search command which filters the list in the detail section.

I want to be able to create a button which previes a LabelsReport based on the filtered list in the form. Any thoughts?

Whatever SQL string value your search form is filtering its records by can be passed to the report so that it mirrors that when it opens.

In the OnOpen event of the report try entering this into the code window

 
Me.Filter = Forms!UserSearchForm.Filter
Me.FilterOn = True
 

If you want to 'see' the value of of your forms filter command at runtime prior to it opening your report then simply place an unbound textbox on the search form somewhere and set its controlsource to this

=[Form].Filter

Regards

Jim :)