I have a form with several fields from a table. I also have a combo box with a drop down to a different table. The form is a data entry form so that when it is first opened, it is opened to the next new record.

I want several of those values to remain after the new record button is pressed. I can accomplish this with the fields entered through the Add Existing Fields method. In the After Update property I have the line:
Me.ControlName.DefaultValue = "'" & Me.ControlName.Value & "'"
However, this does not work for the combo box. I get an error when trying to run this.

Can anyone help me?