S
Stuart
I have a simple form, which is based on a table. I need to open a report
that is based precisely on what is currently displayed on the form. The user
is allowed to filter and sort the data on the form prior to opening the
report using the standard funnel and A-Z keys on the tool bar. I've tried
report.filter = form.filter, but Access seems to have put some strange syntax
into the form filter and I can't manage to use it. Any suggestions as to
how to get the precise recordset from the form as recordsource for the report?
Thanks, Stuart
that is based precisely on what is currently displayed on the form. The user
is allowed to filter and sort the data on the form prior to opening the
report using the standard funnel and A-Z keys on the tool bar. I've tried
report.filter = form.filter, but Access seems to have put some strange syntax
into the form filter and I can't manage to use it. Any suggestions as to
how to get the precise recordset from the form as recordsource for the report?
Thanks, Stuart