Main Form & Sub Form

[Hazo69]

I have a main form and 2 sub forms
Problem is i would like yes/no field in main form to automatically update when sub form sor no is selected
Can anyone help

 

[dsfcom]

Perhaps the OnEnter event of the appropriate subform control can update that for you? You could use something like:

[Forms]![frmMyMainForm].[MyYesNo]=True

as the underlying code for this event which should check the box for you when the subform is entered (gets focus; but not to be confused with the OnFocus event). Then if you wanted to return the checkbox to false use the same line in the OnExit event of the same subform and change "True" to "False".

 

[doco]

sor no is selected

???