I need to create a default value in a subform, within the subform are 2 fields 'Action' & 'Date'. The Action 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?