Is it a good idea to create my own navigational buttons ??

[Guest]

I have a new requirement to lock and unlock specify fields on the form such
that users can or cannot edit data field depending on the condition of other
fields. For example, if the record displayed is Approved by a supervisor
(indicated by the "Approved" field in the record, I'd like to LOCK the field
such that other users cannot modify the contents of certain fields. If it is
NOT approved, the user can still modify certain fields of the record

At present, I'm using the default Navigational Button at the bottom of the
form to allow users to browse the record.

Is it a good idea for me to disable the Navigation Button feature in the
form and then create my own set of Next Record, Previos Record, New Record,
etc buttons to brows the record such that I can enable/disable the field
based on the condition of one of the record field ? If so, can somone
provide me some guidance on how to do it ?

If it is not a good idea, can someone advise a method to achieve this
objective ?

 

[Rick Brandt]

I have a new requirement to lock and unlock specify fields on the
form such that users can or cannot edit data field depending on the
condition of other fields. For example, if the record displayed is
Approved by a supervisor (indicated by the "Approved" field in the
record, I'd like to LOCK the field such that other users cannot
modify the contents of certain fields. If it is NOT approved, the
user can still modify certain fields of the record

At present, I'm using the default Navigational Button at the bottom
of the form to allow users to browse the record.

Is it a good idea for me to disable the Navigation Button feature in
the form and then create my own set of Next Record, Previos Record,
New Record, etc buttons to brows the record such that I can
enable/disable the field based on the condition of one of the record
field ? If so, can somone provide me some guidance on how to do it ?

If it is not a good idea, can someone advise a method to achieve this
objective ?

There is a pefectly good event that is meant to be used for this. The Current
event of the form. Put your code there and it works no matter how the user
arrives at the record (and there are LOTS of ways besides the buttons at the
bottom).