Function to Lock Edits?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

Is there a Function that will lock (or unlock) editing for all fields on my
form?

Would be useful.

Thanks.
 
Bill,

For the whole form have a look in Help at the Allow Edits,
Allow Deletions and Allow Additions properties in Form
Design view property sheet.

For individual fields look at Enabled, Locked and Tab Stop.
 
Bill,
Usually, you would need to designate some "rule" for locking your
records. For example, if a certain field is not Null, then lock the record,
or... for another example, if a checkbox named Locked is True then lock the
record.
Using the OnCurrent event for the form, the easiest way is to lock the
whole record is to set the Allow Edits property to False.
hth
Al Camp
 
Back
Top