Set Default Value in a list

MadeCurler

enthusiastic pensioner
Local time
Today, 22:18
Joined
Dec 6, 2007
Messages
49
I have a value list on a form (the list is called Combo53 where I typed in the values) of 15 reports in my Db. When the form loads the value list appears with no text showing, but all the reports appear in a drop down list. How do I get the form to load with the first item in my list of reports showing.

I've tried...

Private Sub Form_Current()
Me.Combo53.DefaultValue = Me.Combo53.ItemData(0)
End Sub

..but that doesn't work.

I've also tried setting the "default value" in the Combo box's properties but I'm not sure what format that should be in (="firstItem" or whatever?)
 
I think I figured it out....this works

Me.Combo53.Value = Me.Combo53.Column(0, 0)
 

Users who are viewing this thread

Back
Top Bottom