Parameter value pass to a text box

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

So-Ange - 30 Dec 2005 14:30 GMT

I have a 2 Reports that are based on a 2 parameter queries: These
reports should be place on another report as subreports and the main
report will have no record source. Right now I have the 2 reports in
the detail of the Main Report right under each other and it is working
fine.
This is the problem I have.
a.) The param1 ask for the project number and param2 ask again which is
the same value.
b.) I have a button that opens the report. What I will like is for the
user to enter the value of Param1 which is equal to Param2 base on
that Value It displays the Project name in a text box in the page
header. I will really appreciate all the assistance I can get with
this button event code.

Reply to this Message

Duane Hookom - 30 Dec 2005 14:46 GMT

Don't use parameter prompts. Kick your development up a notch and use
controls on forms for users to enter criteria. Your criteria would change
from:

Between [Enter Start] and [Enter End]
to
Between Forms!frmYourForm!txtStart And Forms!frmYourForm!txtEnd

I don't know what you are asking in b.).

Signature

Duane Hookom
MS Access MVP
--

>I have a 2 Reports that are based on a 2 parameter queries: These
> reports should be place on another report as subreports and the main
[quoted text clipped - 9 lines]
> header. I will really appreciate all the assistance I can get with
> this button event code.

Reply to this Message