Combo Box Starting Point

[JWeaver]

I have a combo box that contains a list of dates, starting in January and
going through December. When the list drops down, is there a way to set it
so that it begins with the first date from the current month instead of
starting with January? I would want to then be able to scroll backwards if
necessary.

 

[John W. Vinson]

I have a combo box that contains a list of dates, starting in January and
going through December. When the list drops down, is there a way to set it
so that it begins with the first date from the current month instead of
starting with January? I would want to then be able to scroll backwards if
necessary.

What's the Rowsource of the combo box? Where do the dates come from?

You could certainly limit it to dates starting with this month by putting a
criterion on the date field of

= DateSerial(Year(Date()), Month(Date()), 1)

on the date field; it'll be a bit harder to have it drop down "in the middle",
so to speak. You might be able to do so by setting its default value to

=DMin("[datefield]", "[tablename]", "[datefield] >= #" &
DateSerial(Year(Date()), Month(Date()), 1) & "#")