Report on Filtered Form

[katiekat]

Hi there all,

I have a form that users are going to want to filter and then use the return from the filter to print off a report. Is there a way to take a user-defined filter and pull it into a report right from the form?

Thanks a bunch! Holy tek-tips batman!:-0

 

[braindead2]

have not tried this but should work

dim strcrit as string
strcrit = me.filter
docmd.openreport "your report",acviewnormal,,strcrit

 

[katiekat]

This is exactly what I was looking for. Thank you very much. Works great! Holy tek-tips batman!:-0