Duplicate Entry Error Message

NeroMaj

Registered User.
Local time
Yesterday, 19:37
Joined
Sep 13, 2010
Messages
34
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

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:
Do you have code behind that SubForm or are you just using controls bound to fields in the RecordSource of the SubForm?
 

Users who are viewing this thread

Back
Top Bottom