User-customized report

  • Thread starter Thread starter Bruce
  • Start date Start date
B

Bruce

This is a repost. I have received no replies to the
original posting, so I am trying again with a new title.
I have a report that is a fax requesting certain
information from a vendor. I click a command button at
the vendor form to generate the fax for just that vendor.
The only thing that needs to change is the name and title
of the person sending the fax. I am thinking I need to
have a command button on the vendor form to open another
form where the user adds name and title, with a command
button on that form to open the fax form. The name and
title would come from the intermediate form, while the
rest of the report would come from a table (as it does
now). Am I on the right track? Can somebody fill in a
few details of how best to go about this?
 
The 'fax' is a report based on a query (I assume). Just add an unbound text
box to your report. Make the contents something like...

=[EnterName]

add a separate one with contents like...

=[EnterTitle]


When you run it, a prompt will ask the user for each of tose items before
building the report.


Rick B


This is a repost. I have received no replies to the
original posting, so I am trying again with a new title.
I have a report that is a fax requesting certain
information from a vendor. I click a command button at
the vendor form to generate the fax for just that vendor.
The only thing that needs to change is the name and title
of the person sending the fax. I am thinking I need to
have a command button on the vendor form to open another
form where the user adds name and title, with a command
button on that form to open the fax form. The name and
title would come from the intermediate form, while the
rest of the report would come from a table (as it does
now). Am I on the right track? Can somebody fill in a
few details of how best to go about this?
 
Thanks. That did the trick. Somehow I missed that I
could add a parameter directly to the report (as opposed
to the query). I see that I could also use a form to
enter that information, just as I have used a form for
entering the parameters. This is a great help, and really
so simple now that I see how it's done. Thanks again.
 
Back
Top