Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Display a form's filter in the report header

Status
Not open for further replies.

Board2Death

Technical User
Apr 27, 2005
88
US
I am opening a report with the following code from a button on frmMain
Code:
DoCmd.OpenReport "rptData", acPreview, , Me.Filter
I would like my report to display the filter for the form in the header of the report. To complicate the issue even more, the actual filter may be 300+ characters long.
 
Never Mind...I figured it out.

I created a function that returns the filter. Then I created a textbox on the report and set it's control source to the function.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top