Parameter value pass to a text box

  • Thread starter Thread starter So-Ange
  • Start date Start date
S

So-Ange

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.
 
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.).
 
Back
Top