Form Check Box

[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

 

[fredg]

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

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.

 

[Ayyad K]

Thanks that worked

Ayyad