Locking a record in a 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

 

[vbaInet]

On the Got Focus even of EACH control you:

1. Check whether the Payment field contains a payment or not (of if you have a Yes/No field confirming part payment)
2. IF it has then you LOCK all the controls
3. ELSE UNLOCK all the controls.

 

[gemma-the-husky]

or you COULD just do this, in the current event of the subform

me.allowedits = me.newrecord


then the controls will be unlocked for a new record, but locked for any existing record