Locking Records in Subform

[MuskokaMad]

Hello and thank you in advance for your assistance.



I have a FORM frm_Layaway that allows a customer to put an item on hold with partial payment. The Payment tab contains a SUBFORM sfrm_PaymentDetails that displays the payments in continuous form view (This allowed the sales person to process multiple payment methods).

Later I want to allow the customer to finish Paying for the Order perhaps using multiple Payment methods.

If I call the Payment Subform in Continous Forms View I can't Lock individual Records. What I want to do is make it so that the clerk doesn't accidentally modify or delete an earlier payment.

Any suggestions would be greatly appreciated!

Jason

[llkhoutx]

Lock all records in the subform, then when a record (1) gets focus, unlock it, and (2) when it loses focus, lock it.