lock down the records on the form when a flag is marked "yes"

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

Guest

I want to lock down some of the records on the form where the flag column for
that record is marked "yes".

for example I want to nobody can change the "Purchase Order table/query" via
"Purchase Order form" if one control/column named "Status" of the "Purchase
Order" form/table has been marked as "Finished".
They can view the Purchase Order form and navigate the records but can not
update the Purchase Order information as soon as the "Status" is "Finished".

I think I can not using "On Open" event procedure of the form because
"OnOpen" only trigged when the form is opened, but I need navigate the record
and if the status is "Finished" on that purchase order record then lock down
all the controls on the form by using "setvalue" for the enable property, am
I right?

So on the form which event I should use? any solution for that? I would
appreciate your answer or comments!
 
Jessica:

This same type of question was just answered a day or two ago. This is a
very common request.

Please do a search and look at previous posts. There is no need to retype
an answer if you can simply reread the previous posts.

The key is to use the "on current" event to do your checking as you move to
different record.


Rick B
 
Back
Top