Use Form to Enter & STORE Report Criteria

[Guest]

I created an attendance database. Every day you would enter the date of
attendance. I would like to "reuse" this date for other forms/reports w/o
having the person constanly retype 10/4 (for example).

Right now my query is [Forms!]![fAttendanceDate]![Attendance Date].

On my form I have an Event Procedure on Open
DoCmd.OpenForm "fAttendanceDate"

When my report opens, it's prompting me twice--1st from my query to enter (I
enter 10/4) then it seems like it's opening my form and I enter 10/4 a 2nd
time?

I want to open my form and have my Form Pop up--enter today's date 10/4 and
never have to enter 10/4 again--use 10/4 to print my reports, etc.

THANKS!!!!!
Is there a way of stor

 

[Guest]

Since your queries, forms, and reports will need this date, you need a place
to store it as long as the application is runnning. The first thought would
be to create a global variable; however, queries cannot see any variables.
They have to have either a function or an object reference.

What I would recommend would be to create a form that that opens when you
open the applicaton with a text box for the user to enter the date. Once the
date is entered, hide the form, but leave it open. Then reference the
control on that form in all the places you need it.