Form Check Box

  • Thread starter Thread starter Ayyad K
  • Start date Start date
A

Ayyad K

Hey, I am not that familiar with forms, but I have managed to create
one that as 2 user inputs... DateStart, and DateEnd

Along with 5 other buttons that run queries, every query has a date
field and i set their criterias to be...

Between [Forms]![Query Dates]![DateStart] And [Forms]![Query
Dates]![DateEnd]

But what if i would like to have a check box that makes the dates for
the
'DateStart' to be =Date()-7
'DateEnd' to be =Date()

Or if there is anyway i could make those the default values in case the
user does not input any values

Thanks in advance

Ayyad
 
Hey, I am not that familiar with forms, but I have managed to create
one that as 2 user inputs... DateStart, and DateEnd

Along with 5 other buttons that run queries, every query has a date
field and i set their criterias to be...

Between [Forms]![Query Dates]![DateStart] And [Forms]![Query
Dates]![DateEnd]

But what if i would like to have a check box that makes the dates for
the
'DateStart' to be =Date()-7
'DateEnd' to be =Date()

Or if there is anyway i could make those the default values in case the
user does not input any values

Thanks in advance

Ayyad
Click to expand...

Set the default value for the DateStart control to:
Date() - 7

Set the default value for the DateEnd control to:
Date()

If the user does not enter anything, the queries will use those dates.
If the user does enter something, the new dates will be used.
 
Back
Top