Entering parameters only once...

  • Thread starter Thread starter Rich
  • Start date Start date
R

Rich

I have created a program that creates a file that inputs
information into Quickbooks from data in Access. The
program works fine. The program operates on data that
exists between a start date and end date that is entered
by the user. i.e., 6/1 through 6/15. My employer wants 2
different reports to print out when he runs this program
also that gives him different information for recording
and verification purposes. These reports use the same
date parameters as the program itself. When the program
is exectuted, it promps the user to enter the dates, then
again for the first report, then again for the second
report (using the DoCmd.OpenReport... command). As these
are the same dates being entered 3 times, I was wondering
if there was a way for them to only be entered once.
Thank you.
 
Create a form that is opened (frmByDateRange) before the reports. Require the user to enter the dates into two textboxes on this form (txtStartDate and txtEndDate). Then, change your criteria to Forms!frmByDateRange!txtStartDate and Forms!frmByDateRange!txtEndDate. In this way, the user only enters the date once.

Jake
 
Back
Top