C
Cameron
I have been getting an error num ber 3022 when I click close on this form I
have been working on. I do not understand why the form is doing this. This
table is indexed, but not with a Primary Key. The field allows duplicates but
is filled via and autonumber type.
My close button data is as follows:
Private Sub cmdClose_Click()
On Error GoTo Err_cmdClose_Click
If Me.Dirty Then Me.Dirty = False
DoCmd.Save
DoCmd.Close
Exit_cmdClose_Click:
Exit Sub
Err_cmdClose_Click:
MsgBox err.Description
Resume Exit_cmdClose_Click
End Sub
The employee table is however linked to other tables. I just do not know how
come this is happening. If I venture to enter data in the table directly it
works fine. If I enable navigation buttons on the form and use the new record
selection from there the records save, but my code will not and thus produces
the anoying error.
Any help would be appreciated...
have been working on. I do not understand why the form is doing this. This
table is indexed, but not with a Primary Key. The field allows duplicates but
is filled via and autonumber type.
My close button data is as follows:
Private Sub cmdClose_Click()
On Error GoTo Err_cmdClose_Click
If Me.Dirty Then Me.Dirty = False
DoCmd.Save
DoCmd.Close
Exit_cmdClose_Click:
Exit Sub
Err_cmdClose_Click:
MsgBox err.Description
Resume Exit_cmdClose_Click
End Sub
The employee table is however linked to other tables. I just do not know how
come this is happening. If I venture to enter data in the table directly it
works fine. If I enable navigation buttons on the form and use the new record
selection from there the records save, but my code will not and thus produces
the anoying error.
Any help would be appreciated...