MadeCurler
enthusiastic pensioner
- Local time
- Today, 07:01
- 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'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?)