Combo box default value

[mikemaki]

I have an unbound form that I use to gather information to use as query criteria to populate another form. This form has a combo box that I would like to open with the default value of "All Tests" which is the first value in the query behind the combo box. I have tried setting the combo box equal to 1 in the onload event, I have tried setting it equal to "All Tests" in the load event, I have set the default property equal to 1, I have set the default value equal to "All Tests." All these result in a blank combo box. Can anyone helpme initialize this object?

 

[Dave Eyley]

In the Combo's Default Value Property type in the value from the query that you want as the default.

It should work OK.

Dave E

 

[dgm]

If you put
cboMyComboBox = cboMyComboBox.Column(0,0)
into the forms open event it will select the first item in your combobox.
The default value works ok for value lists but not sure if it works for queries???

Dave

 

[Guus2005]

Thanks, i was looking for this!