Ok Guys need some help.

I'm almost finish with a project but I'm stuck with a combo_box problem. How can I set the combo_box to display the first record in the recordset(actually a query) when the form is open?

Currently when the form is open it is blank until the user presses the down arrow and select a person's name. The combo_box is use to select records in a subform.

Thanks in advance for any help.
Del

Your question was intriguing, but I couldn't find the answer.

Could you utilize the GotFocus event here?


Me.ComboBoxName.Dropdown

If your list is prepopulated, you could try me.comboboxname.itemdata(n) where n is the number in the dropdown list. 0 is the first value in the list.