Combo Box default in form

[ssmith001]

I have a combobox called cboMaxVal. When I open a form called frmMain, I want value in the cboMaxVal to be set to the query qryGetMaxVal.

Currently when I open the form, I need to click on the dropdown arrow before I can see the value from the query. Is there a way to have it appear in the combobox without having to click the dropdown?

 

[mhartman]

Yes. You set this "Default Value" in the properties of the combo box.

Regards

 

[ssmith001]

Set it to what? The name of the query?

 

[mhartman]

The "Default Value" property of a combo box allows you to initially set the value you want displayed in the combo box window when the form is opened.

If this happens to be the name of a query that you want displayed, then place that in the default value property.

Regards
Mark

 

[ssmith001]

For some reason it's not working. Please take a look at the attachment.

 

[mhartman]

Here you go.......

Regards

 

[ssmith001]

This is not right. I wan't the combobox default to be the result of the query called QRY, which in this case if 5.