Is this Possible

[Guest]

I have several queries that generate "Approval Letters", now here is the
issue, one company uses two different "Approval Letters" depending on the
project. I'm trying to set up the reports so that 1. The user will have the
option to choose from the two letters, this isn't the issue, the issue is 2.
I need Access to record the choice made so that when a report is run or the
"Approval Letter" needs to be reprinted it will automatically choose the
right option.

Or would it be easier (and how can I) assign the proper option at the time
the new project is created in the database?

 

[RBear3]

If I understand your question....

Just modify your report/query that prints letter 2 to only select records
marked with a "2". Modify your other report/query to only select records
marked with a "1".

 

[Guest]

Thanks, I kinda figured it out after that I would have to set the option with
the initial project setup seems my new company has a lot of second options.

 

[Mr. B]

If I understand your question....

Just modify your report/query that prints letter 2 to only select records
marked with a "2". Modify your other report/query to only select records
marked with a "1".

--
Hope that helps!

RBear3
.







- Show quoted text -

Hi, Lori.

If you have information in the data that would tell you which of the
"Approval Letters" you user should use in a given instance, you can
simply check the appropriate value in the data and then, using code,
you can determine the correct report name to be printed based on the
value in the data and print that report.

On the other hand, if you just want your user to be able to select the
"Approval Letter" they want to use then, assuming your users are
running these reports that print the "Approval Letter" by clicking a
button on a form, just add an option group to your form, making the
two options the two available reports. You can even set the option
group to be defaulted to the most appropriate option or to neither
option.

Then after the user has selected the report to run, just either use an
IF statement or a Select Case statement to check the value of the
option group and print the correct report based on that value.

Hope this helps.

Mr. B