I Can Still Change Data After Invoicing

[geo40]

Dear Sirs,

I managed a database for invoicing. The database contains a lot of self-made columns, and data-input by self-generated MS Access forms. So a lot of valuable information has been generated. These database is used by several persons.
My problem is that after I print my invoice, I or a collegue ( (un)-conscious ) can change data.

Is there a handling in MS Access to prevent this ?? So after I print the invoice, I can't be possible anymore to change anything from the printed invoice.

GEO40

 

[hymn]

I have a field that if it has data in the record is locked the field is called Signed


'If the Signed Date field has data then the record is locked

If Me!Signed > 0 Then
With frm
.AllowAdditions = False
.AllowDeletions = False
.AllowEdits = False

End With
Else
With frm
.AllowAdditions = True
.AllowDeletions = True
.AllowEdits = True
End With
End If

hope this helps