I have a combo box on a form that when I open the form I want to have that combo box displaying a value I send from the previous form.

For example:

BoxList has 4 values from a query (a, b, c, and d). When I open the for with BoxList it shows blank and then I can choose from the drop down.

The previous form can pass a value (a, b, c, or d). Using this value I want BoxList to display that row when I open the form. I still want to be able to choose another value from the drop down if the users wants to change it.

Note: The query behind the combo box uses 2 columns, an ID column and a Description column. I want to be able to pass the ID from the previous form.

Also note, the previous form may pass a null value as the ID if the user is setting the value for the first time.

I hope this makes sense.

Thanks,
Matthew..