I have a combo box with a rowsource type of table/query
and rowsource of SELECT tblStatus.StatusID, tblStatus.Status FROM tblStatus;
it has two choices: active or in-active

i want to set the default value to active, but am not sure how to do this since it is through an ID.

Hi;

What would be the StatusID for active?

Then place that value to the default value.

For instance.

StatusID -- Status
1 -- active
2 -- inactive

Then in the combo box property

Bound Column : 1
Default Value : 1
Column Count : 2
Column Widths : 0";1.5"

HTH.