how to lock a form and subforms

  • Thread starter Thread starter Alan
  • Start date Start date
A

Alan

Hello,

I have a form that also contains subforms. What I would like to achieve is
when a salesman is finished creating his quote and ready to finalize it, I
would like to set a control (ie. toggle button, checkbox) where he can
toggle/check off to lock the quote down so no one else can tamper with it.

What's the best way to accomplish this?

Thanks in advance,

Alan
 
it depends on how savvy the other users are....and whether they all share one
machine or whether this is a multiuser environment...

the data ultimately resides in a table; if the users are not too savvy just
set the form's Property to "Add Data"...every time the form opens it will
only open to a blank new record for data entry and one can not browse records
with this form...

however limiting accessibility of the underlying table is another story and
you should do a search on 'security' for more in this area...

hth
 
It's a multi-user environment where the database sits on a shared network
drive that has Active Directory security group settings restricting anyone
who doesn't have access from going through the "back door" opening the folder
containing the front and back end files and mucking with the tables.

On the front end side the users all run an MDE version through a Citrix
session that also has an MS Access security session set so they all have
individual logons with group associations limiting their access to only
certain areas of the database based on the group they belong to.

I think I figure it out and have it set up so that the form (and subforms)
is frozen when a checkbox is set to true which then disables itself so the
only way to unfreeze that form for that specific quote is to go into the back
table and uncheck the checkbox which is an actual field in the main table.

The users aren't very savvy so hopefully this accomplishes the task.

Thanks for the feedback.
 
Back
Top