Hi
SubForm1 and SubForm2 (based on queries) are two Sub Forms on a Main Form. Each record in SubForm1 shows related records in Subform2.
A Yes/No field is on SubForm1 with default value= Yes. I want to write criteria for the Yes/No field BeforUpdate Event so that it will not to be updated (chnaged from Yes to No) if records exists in subForm2.
How can this be done?
KHalil