I need to create a default value in a subform, the subform has 1 field called 'Action'. This field is a combo box and the row source data comes from a table storing the variables a user can select.

Within this table is a value called 'Open', I would like this to be the 1st record in the subform of every new record created.

Any ideas?