roll security

[tony wong]

i have a sub-table showing records which are paid or unpaid.

i want to lock paid records

and to allow unpaid record to be edited by user.

Can i do it by Access XP?

Thanks a lot.

Tony

 

[Rick B]

In the form's "on current" event, you would need code to set the record's
"locked" property to true if the record is paid.

Is there a "paid" checkbox?


Rick B


i have a sub-table showing records which are paid or unpaid.

i want to lock paid records

and to allow unpaid record to be edited by user.

Can i do it by Access XP?

Thanks a lot.

Tony