Rolling 12 months in a combo box in access

[kacocal]

Do you know how to code the rolling 12 months in a combo box?


(1) When I click on the combo box this month, the first value should be 2015-07 (yyyy-mm) and the last one should be 2016-06
(2) When I click on the combo box next month, the first value should be 2015-08 (yyyy-mm) and the last one should be 2016-07.



The combo box will check today's month and will automatically generate the 12 rolling months (include this month).


Please give me some ideas.

Thanks.

[orange]

You are going to have to show us some code or screen captures to show us what you are talking about. The post is too vague at the moment without some reference specific to your materials.

[June7]

Unless you have a table that can serve as the source, requires VBA code to build the combobox RowSource. In form Open event, something like:

For x = 0 to 11
Me.comboboxname.AddItem Item:=Format(DateAdd("m", x, Date), "yyyy-mm"), Index:=0
Next

https://msdn.microsoft.com/en-us/lib...or=-2147217396

[kacocal]

Thank you very much.

Unless you have a table that can serve as the source, requires VBA code to build the combobox RowSource. In form Open event, something like:

For x = 0 to 11
Me.comboboxname.AddItem Item:=Format(DateAdd("m", x, Date), "yyyy-mm"), Index:=0
Next

https://msdn.microsoft.com/en-us/lib...or=-2147217396