Print or Export the results of a Filter (not query

Topic

New Reply

Access 97

I want to write VBA code for a “Print” button in a form that prints a report using only the currently displayed (filtered) data.

I have a Form with buttons set up to allow the user to easily filter records. Once the user has filtered the records, I need to give them the option to print a report (and/or export) based on the filtered (not query criteria) data.

I want the user to dynamically be able to use the user-friendly filtering tools rather than parameter queries.

Reply | Quote

Replies

You may want to look at the ACCESS MVP website and use the code posted there by Dev Asish.

Dim strDocName As String
Dim strWhere As String
strDocName = “rptSomeReport”
strWhere = “[RunID]=” & me!RunID
DoCmd.OpenReport strDocName, acPreview, , strWhere

This prints only the current record.

Reply | Quote

Here’s a link to a previous discussion on printing the current record as well.

Reply | Quote