CBO Default value Current Month

[Tuckejam]

Ok I have tbl_transactions which has transaction data, each with a transaction date



then I have qry_MonthExpReport

the qry uses functions to extract (in separate columns) the year of the transaction and the month of the transaction

and then i have frm_MonthExpReport that has combo box with a dropdown of the year and the month to pull the data from that year and month

The drop down cbo uses the month names typed into its row source property for its values (maybe there is a different better way to do that?)

anyway I would like the form to open with the current month a year selected, I know I can select a default value of today's date but how do i do that for the month??

(bonus question, is it possible to load images that are less gigantic?)


Thanks for the help

[ranman256]

instead of a VALUE LIST, use a table, with numeric values
1,January
2, Feb..

the value can be 1 and the combo display January
default of cboBox = month(date)

column widths: 0;2
hide the numeric, show the text

[Tuckejam]

Ranman256

If i set it up that way, how does it get me closer to setting the default value as the current month??

[Bob Fitz]

...anyway I would like the form to open with the current month a year selected...

Why not just use:
DoCmd.GoToRecord , , acLast

in the forms Open event.

(bonus question, is it possible to load images that are less gigantic?)

I have no idea, but remember, some of us are OLD with failing eyesight, amongst other things

[ssanfu]

If I understand correctly, you want the unbound controls "cboYear" and "cboMonth" to be set to the current year and current month name when the form "frm_MonthExpReport" opens.
You can use Value Lists or you can use Functions to fill the combo boxes. To have the current year and month, you can set them in the form open event.
See attached dB

[Tuckejam]

ssanfu

Thank you that was exactly the stuff I was looking for,
will take me a bit to get to it and take it all apart and understand it better, but thank you for the examples

[ssanfu]

You are very welcome.
Good luck with your project.