Printing filtered data from form

K

KRB

I have a very simple form to keep track of training classes. I want to be
able to print out a list of people for the specific date that I filter on.
How do I do that? I have a preview button I have created on the forms page,
but it previews all the data I have in the database. I just want it to
preview for that specific criteria I filtered on, without having to create
several different reports.Could you please Help?
Thanks,
 
F

fredg

I have a very simple form to keep track of training classes. I want to be
able to print out a list of people for the specific date that I filter on.
How do I do that? I have a preview button I have created on the forms page,
but it previews all the data I have in the database. I just want it to
preview for that specific criteria I filtered on, without having to create
several different reports.Could you please Help?
Thanks,
Click to expand...

I guess it depends upon 'how' you filter the data.
You might try:

DoCmd.OpenReport "ReportName",acViewPreview, , Me.Filter

Otherwise let us know what your filter is.
 
S

Sprinks

KRB,

There are several ways to do this. One way is to provide an unbound control
on your form for the date (or two for a beginning and end date). Then create
a report based on a query that uses the entered value (or values) as
criteria. The criteria specification syntax is:

=Forms![YourForm]![YourControl] (one specific date)
or
Between Forms![YourForm]![YourControl] AND
Forms![YourForm]![YourOtherControl]

Then either base the report on the query, or preferably use the optional
Filter By parameter of the OpenReport method:

DoCmd.OpenReport "Your Report", acViewNormal, "YourFilterQuery"

Hope that helps.
Sprinks
 
Top