Update or CancelUpdate without AddNew or Edit
I have searched the forums for an answer to this, but haven't found anything quite specific enough for my situation.
I have a subform with the navigation buttons enabled. When i click the button to add a new record it bring up the default values in the combo boxes, however, when I try to type a new value in any of the boxes it gives me the above error message. It does this for combo boxes, text boxes, date boxes, and check boxes.
Every field on the form gives this error message.
i have seen the following as a solution
but I have no idea where I would even begin to use it.
I have searched the forums for an answer to this, but haven't found anything quite specific enough for my situation.
I have a subform with the navigation buttons enabled. When i click the button to add a new record it bring up the default values in the combo boxes, however, when I try to type a new value in any of the boxes it gives me the above error message. It does this for combo boxes, text boxes, date boxes, and check boxes.
Every field on the form gives this error message.
i have seen the following as a solution
Code:
If Me.Dirty Then
Me.Dirty = False
End If
but I have no idea where I would even begin to use it.
Last edited: