Month and Year Combos

[Drummermoose]

I want to be able to have 2 combo boxes, 1 with a list of months and the other with a list of years (4 digit).

Also I would like it to default to the present month and year when you input a new record.

Any Ideas!

Thanks in advance

Ben

 

[Drummermoose]

Any Ideas! or maybe there's something similar I could use that will do the same job.

Any help would be appreciated.

Thanks,

Ben

 

[TerpFan2001]

Moose:

Set the Row Source Type for each ComboBox to "Value List", then under RowSource, type in the values you want...

cboMonth.RowSource = January;February;March...

I assume these the data from the combos is coming from a date fields in a table. If so, set the format and default properties...

fldMonth.Format = mmmm
fldMonth.Default = Date()

Hope this is what you are looking for.

 

[Drummermoose]

Thanks for the suggestion TerpFan2001. When I add new record now if comes up with the present month, but in number form. Any chance any one could help me to change this to text format.

I also still need help on the year combo box, that lists a continuous amount of years but defaults on the present year on add new record.

I need to complete this database by tomorrow, so any help would be appreciated.

Thanks,

ben

 

[Drummermoose]

After This is sorted I will need to use the months and years in a query to search for records between two groups of a month and year.

i.e Find all records between January 2002 & April 2002

Then the results will display in a report.

Any Ideas.

Thanks,

Ben