Report Using a Forms filtered Record set

  • Thread starter Thread starter Noel
  • Start date Start date
N

Noel

Hi. Sorry to double post but I put this on New Users
yesterday by mistake. Thought Id repost here. Will keep an
eye on both posts.

Ive had an idea for a Report linked to a Form which Im
sure someone must have thought of before but I havent seen
it in any books or sample dbs. Imagine an ordinary Form on
which the user performs the usual Filters and then perhaps
sorts the filtered records. Now imagine they click on a
command button at the bottom of the form which opens a
predesigned Report, which displays the filtered and sorted
record set. Can this be done? I know how to do everything
but transfer the record set directly to the Report. If its
possible, I would ideally like to be able to build this
around existing forms, as well as designing ones
specifically with this technique in mind. Any ideas and/or
examples? Thanks, Noel
 
Hi Noel,

This can be done. Send me a private message that includes a valid e-mail address, and I
will send you a sample.

Tom

AOS168 at attbi dot com
____________________________________


Hi. Sorry to double post but I put this on New Users
yesterday by mistake. Thought Id repost here. Will keep an
eye on both posts.

Ive had an idea for a Report linked to a Form which Im
sure someone must have thought of before but I havent seen
it in any books or sample dbs. Imagine an ordinary Form on
which the user performs the usual Filters and then perhaps
sorts the filtered records. Now imagine they click on a
command button at the bottom of the form which opens a
predesigned Report, which displays the filtered and sorted
record set. Can this be done? I know how to do everything
but transfer the record set directly to the Report. If its
possible, I would ideally like to be able to build this
around existing forms, as well as designing ones
specifically with this technique in mind. Any ideas and/or
examples? Thanks, Noel
 
Back
Top