Reports

[Guest]

I want to apply a filter to a form based on a single table & then use a
"PRINT" command button to open a report that will only show the filtered
records. Where is the best place to look to get ideas on how to do this?

Thanks, Garry Gross

 

[Rick Brandt]

I want to apply a filter to a form based on a single table & then use
a "PRINT" command button to open a report that will only show the
filtered records. Where is the best place to look to get ideas on
how to do this?

Thanks, Garry Gross

As long as the two record sources are similar enough that the same filter will
work, try...


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

 

[Guest]

Rick,
Tried it and it doesn't work consistently. The form is based on a table
that has 4 text fields. It works for 2 of the fields, but not for the other
2. It doesn't work for any of the number fields or for the combo boxes. In
all those cases I get a message box asking me to "Enter Parameter Value".
I know it can be done, I've seen databases that do it, but I haven't
been able to interpret how it was done. Any references or articles on this
website that might help me?

Thanks again, Garry Gross

 

[Daniel Rankin]

I likw these news groups and they are very cool

Rick,
Tried it and it doesn't work consistently. The form is based on a table
that has 4 text fields. It works for 2 of the fields, but not for the other
2. It doesn't work for any of the number fields or for the combo boxes. In
all those cases I get a message box asking me to "Enter Parameter Value".
I know it can be done, I've seen databases that do it, but I haven't
been able to interpret how it was done. Any references or articles on this
website that might help me?

Thanks again, Garry Gross