locking records

  • Thread starter Thread starter 111
  • Start date Start date
1

111

Is there a way to have a control in a form (check box) which once the checkbox
has been 'clicked' the other controls in the form can be viewed but not
changed?

I'd like this over a network where on the admin computer I can lock certain
records (via the check box) and other users can view the data on their
computers (their own version of the application would have to understand that i
locked the record and not let them alter the data).

Tks
Steve
 
Hi Steve

In your form's Current event, set the AllowEdits property appropriately:

Me.AllowEdits = Not Me.chkLocked

If you want to lock controls more selectively, you can use their individual
Locked properties.

--
Good Luck!
Graham Mandeno [Access MVP]
Auckland, New Zealand

Return mail address is invalid in a vain attempt to reduce spam.
Feedback is welcome at: (e-mail address removed)
Please post new questions or followups to newsgroup.
 
Back
Top