Setting up default value in combo box using different table.

[haritbhasin]

Hi,


I want to set a default value in a combo box. The source of the combo box is another table. I am able to pull the values from the this table in the combo box. I am able to select the values. But i want to set a default value in the combo box from the source table so that if no value is selected then that default value should be there.

 

[John Big Booty]

With your Form in Design view simply select you combo box, and then in the properties value click on the Data tab and set your Default value this value will correspond to the value held in the bound column of the combo box, that represents the value you wish as your default.