Help with a Yes/No Box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a main form that has a Yes/No field on it. The main form has a
subform with 4 text fields and 1 memo fields. I do not want the Yes/No Box
on the main form to be enabled unless all the fields on the subform have
something in them.

Can someone show me the syntax of how to write this in VBA? Thanks...
 
Don said:
I have a main form that has a Yes/No field on it. The main form has a
subform with 4 text fields and 1 memo fields. I do not want the Yes/No Box
on the main form to be enabled unless all the fields on the subform have
something in them.
Click to expand...


I think you need to use the code in the subform's Current
event and the AfterUpdate event of all 5 sunbform controls:

Me.Parent.checkbox.Enabled = Not (IsNull(txt1) Or
IsNull(txt2) Or . . .)
 
Back
Top