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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Closed records

Status
Not open for further replies.

frattonuk

Technical User
Jan 30, 2006
1
GB
Is it possible to set a script so once a record has a status of closed it can not be amended
 
This would be difficult to do if you allow your users to do FINDS on a form or worksheet where fields are editable. Approach locks at the database level, and not at the record level. So you would need to tightly control the user's ability to get to records without your script or macro checking a record's status. I do not recommend doing this because there are so many ways someone can work around you.

Sue Sloan
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top