I have a Parent Child Database. The Parent has Names & Addresses, while the Child has payment dates & amounts.
Sometimes I want to put check the “NO PAY” box on the Main Form. I wanted the Subform Payment field to be disabled.
In the Main form I checked the “NO PAY” box for 2 Names so that “NO PAY” = -1.
IN the payment field on the subform I put the following code and it does NOT work. Cannot find the Form Name.
In the On Current event of the subform:
If ([forms]![Parent Form]![NO PAY] = -1) then
me.payment.enabled = false
end if
Obviously I am addressing the Main Form with the incorrect format. Can anyone out there help me???
Thanks!
Alan
New York City
