G
Guest
Hi,
Is there a Function that will lock (or unlock) editing for all fields on my
form?
Would be useful.
Thanks.
Is there a Function that will lock (or unlock) editing for all fields on my
form?
Would be useful.
Thanks.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
N
Nick Coe \(UK\)
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.
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.
A
AlCamp
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
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