Combo Box default value

[BamaColtsFan]

I am sure this is a very basic problem but I just can't seem to make it work...

I have a form with a combo box. The values for the combo come from a table listing available month and year of various data. When the vlaue is selected in the combo box, the form refreshes the data to display that month and updates another table with that month that is used for a few different functions. Everything works great except that when you open the form, there is no value displayed in the combo box. What I would like for it to do is display the month that is equal to the value found in the second table, since that is considered to be the current month. I have tried various approaches to setting the default value and using a query in the control source but It still shows no value when opened. Any advice would be appreciated....

 

[mhartman]

Hello:

All that is needed is set the "Default Value" in the properties section for your combo box.

Regards
Mark

 

[Jonathan Kok]

What I would like for it to do is display the month that is equal to the value found in the second table, since that is considered to be the current month.

How exactly is it getting that value? Is it displayed on the current form, or a different form? Is it the very last record in the referenced table?