Print all records on Form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am having a problem. I created a main form that filters many different
options and then opens another form. From there the user can double click
any record to get more detail, but I would like to also give them the option
to print only the records on the form as well in a report. But everytime I
click the button to print the report all the records from the query print.
Not just my filtered records.

Can anyone help me? Thanks!
 
You can apply the form's filter to the report by putting code like this in
the Click event procedure of a command button on your form:
Dim strWhere As String
If Me.Dirty Then Me.Dirty = False
If Me.FilterOn Then strWhere = Me.Filter
DoCmd.OpenReport "Report1", acViewPreview, , strWhere
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sending filtered records from a form to a report. 5
Resetting the form filter filter for a new report 4
Print certain records on report 1
filtering a form based on a filter on an open form 2
Print a report from a form based on a query 4
First Subform record gets modified when closing form 3
Separate Form 0
Printing a Specific Record 1

Back
Top