Manipulate Form Controls at Record Level

Question

I have a continuous form that is bound to a table. Beside each record of my form I have an "Edit" button. I want to know if I can manipulate the form controls at record level, meaning:

when user clicks "Edit" button, the locked property of the current row of record is set to false and only to the current row

when user clicks "Edit" button, two more "Save" and "Cancel" buttons' visibilities are set to true and displayed at the end of the current row of record

Can I achieve this programmatically in vba?

Thanks

Answer 1

Manipulate properties for a control in a continuos form affect to all the rows. But... you can use conditional format: For example, for Save button, you can set the enabled property depending on the Dirty form property.