Apr 10 2006, 07:20 AM
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.
Apr 10 2006, 07:24 AM
What would be the StatusID for active?
Then place that value to the default value.
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"