C
chappie2
I have created a single-line-per-record form based on a
query of two tables. From that form, one can use the
Filter by Form function to select a set of records. I
would then like to be able to use that set of records in a
report.
I have placed an OpenReport button in the footer of the
form and it works fine when the form is based on a single
table, using the Me.Filter option. However, it does not
work with the desired form, because it is based on a
query.
Can someone suggest to me a way to temporarily save the
results of the Filter by Form and use them as the source
for a report?
Thanks.
query of two tables. From that form, one can use the
Filter by Form function to select a set of records. I
would then like to be able to use that set of records in a
report.
I have placed an OpenReport button in the footer of the
form and it works fine when the form is based on a single
table, using the Me.Filter option. However, it does not
work with the desired form, because it is based on a
query.
Can someone suggest to me a way to temporarily save the
results of the Filter by Form and use them as the source
for a report?
Thanks.