default month and year

[beefyalby]

I have a form that has a field with these dates:
1-Nov-10
1-Dec-10
1-Jan-11



I want the form to open up to the date 1-Dec-10 corresponding with the current month and year.

In January, 2011 I want the form to automatically open up with 1-Jan-11 as the default value.

How do I do this?

[HiTechCoach]

I have a form that has a field with these dates:
1-Nov-10
1-Dec-10
1-Jan-11

I want the form to open up to the date 1-Dec-10 corresponding with the current month and year.

In January, 2011 I want the form to automatically open up with 1-Jan-11 as the default value.

How do I do this?

Are you asking about two different things (filter a form and default value of a control)?


It is possible to calculate the start date of the month from the computers current date.

The first day current month: DateSerial(Year(Date()), Month(Date()), 1)

You could use this to as criteria in the form's record source.

[beefyalby]

no, i simply would like the form to open up selecting the record that coincides with the current month and year.
so yes, a default value based on the current month and year

[HiTechCoach]

no, i simply would like the form to open up selecting the record that coincides with the current month and year.
so yes, a default value based on the current month and year

A default value is a property of a control or field in a table.

I am thinking you really are not wanting to set the default property for an object.

I think you want to control the form's record source.

Here are some possible options:

1) Limited to just record for the current month and later?
2) Limited to just record for the current month?
3) All records. Position the form's recordset to have the current record be the first record for the current month.

The first two option can be Done in the query. Or could be done with the form's filter. The filter could later be removed.

Option 3 will require some VBA code.

Which option do you want or is it something else?