Combo Box Default Value

[RGarcia87]

I have a form with a combo box with a list of months. How can I get it to default to the previous month? This is what I currently have in the properties of the combo box (=Format(Date(),"mmm-yyyy")). Currently, if defaults to the current the 1st day of the current month.

 

[HaroldGE]

=Format(Date()-Day(Date()),"mmm-yyyy") 'yields last day of prior month
-or-
=Format(DateSerial(Year(Date()),Month(Date())-1,Day(Date()),"mmm-yyyy")
'yields 1st day of prior month

 

[RGarcia87]

That worked! Thanks alot.