way to save data for revising later but read-only when completed

[mtabt]

I need a way to allow restricted users to save their partially inputted data into a form to be revised at a later date. However, once the input is completed and confirmed, they cannot make changes anymore, thus the data become read-only for them.

Is there a simple way to implement this feature. Any help would be appreciated. Thank you in advance.

 

[DougP]

One way is two have 2 forms. one is for input the other for viewing. Make all boxes on the viewing form "locked" Whihc is set the Locked Propery to "Yes" in the properties. This will not allow then to change anything.

Instruct them to add using form A and view using form B

DougP, MCP

 

[PeteJohnston]

If there is a field on the form which indicates if the input has been confirmed then you could try

Dim ctrl As Control
On Error Resume Next
If Me.YourConfirmedField Then
   For Each ctrl In Me.Controls
     ctrl.Locked = True
     ctrl.TabStop = False
   Next
End If
btnExit.Locked = False

If you put this into the Form_Load event it will lock all of the controls on the form so they can't change anything. This would save you having two different forms which do exactly the same job. Don't forget to unlock any controls which they are allowed to use.

PeteJ
(Contract Code-monkey)

It's amazing how many ways there are to skin a cat
(apologies to the veggies)