Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

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

Status
Not open for further replies.

mtabt

Technical User
Apr 25, 2001
23
US
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.
 
i have field in the table that i use as switches for allowing edits. when they finish entering the data, i update a stop field to "Y" for that record. then if they open a record that has the switch set to "Y" then it does not allow edits.

this is what i have in the form_open section to check the switch:

If [Forms]![QuotationEntryII]![ExportRecExists] = "Y" And _
Not IsNull([Forms]![QuotationEntryII]![ExportStopSwt]) Then
Form.AllowAdditions = False
Form.AllowDeletions = False
Form.AllowEdits = False
Else
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top