Setting combo box default value

G

Guest

I have a combo box that contains the names of the 12 months.
I need to set a default value of the month before the current month.
I'd like to set the default via the offset in the list (via 'Datepart'
function) rather than the month name
e.g. 1 = January, 12=December etc.
Is this possible?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Setting a date field using combo box 3
Setting first row in combo box as default. 3
Default to current month in Access form field 1
Combo Box Starting Point 1
Default value on continuous form from query 2
Unbound Combo Box Default Value Based on Query 10
OnChange combo box 2
Combo Box Default Value 4

Top