Defaults in queries, forms

[Marky]

How can I set Month or Year default as per the system date. ie Only select records by Month (October) or Year (2013) as per system date?

 

[MarkK]

Check out the Month(), Year(), and Date() functions provided by VBA.

To set the Default Value of a control, check out the control's DefaultValue property.

To return records by month and year for a particular date, you can write a WHERE clause like . . .

WHERE Month([YourDateField]) = Month(Date())
   AND Year([YourDateField]) = Year(Date())

hth

 

[Marky]

Thanks a lot, I'll try that. It should work. Just to clarify, a form/report etc should only have this month's records or this year's records without using the filter options. Cheers

 

[MarkK]

Just to clarify, a form/report etc should only have this month's records or this year's records without using the filter options.

Ahh, what is clarified here? You asked cryptically about dates, defaults, and selecting records. Nothing about forms/reports.