Make saved invoice not change

[SAC]

I'm making invoices and after one is made, the user might go back to it to
add, change or delete an item before it is finalized.

How can I prevent them from changing who the invoice is to?

Thanks.

 

[Arvin Meyer]

If you implement security:

http://support.microsoft.com/default.aspx?scid=/support/access/content/secfaq.asp

you can lock the users out of the tables.

In the forms, you write a bit of code like (untested air code):

Sub Form_Current()
If Me.NewRecord = False Then
Me.AllowEdits = False
End If
End Sub

--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access