default shown on combo box (Access 2000)

Topic

New Reply

I have a combo box that is built on a sql statement on a form. I would like to know if there is a way that I can show the default entry (say USA) on this combo box when the form is loaded.

Thank

Reply | Quote

Replies

On the property sheet for the combo box, click on the Data tab. You’ll see a Default Value property field. This is a value that will automatically be loaded each time the form is loaded. Just enter the value you want here.

Reply | Quote

On the property sheet for the combo box, click on the Data tab. You’ll see a Default Value property field. This is a value that will automatically be loaded each time the form is loaded. Just enter the value you want here.

Reply | Quote

Thanks.

What about if I have multiple combo boxes and if I make a selection on a calendar, these boxes will retrieve the data from a table and display the corresponding entries?

thanks

Reply | Quote

I’m afraid I don’t quite understand what you’re asking. How does the selection on the calendar (and which calendar?) effect these combo boxes? Let me say this, however: the default value is set independently for each combo box on a form, and the default value is loaded into the form when the form/record is opened. If you want to change the value of combobox based on other selections on the form you need to look into VB coding. Hope this helps.

-Karl

Reply | Quote

I’m afraid I don’t quite understand what you’re asking. How does the selection on the calendar (and which calendar?) effect these combo boxes? Let me say this, however: the default value is set independently for each combo box on a form, and the default value is loaded into the form when the form/record is opened. If you want to change the value of combobox based on other selections on the form you need to look into VB coding. Hope this helps.

-Karl

Reply | Quote

Thanks.

What about if I have multiple combo boxes and if I make a selection on a calendar, these boxes will retrieve the data from a table and display the corresponding entries?

thanks

Reply | Quote