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 . . .)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Form with Subform and a Yes/No field 1
Populate a field based on a visible value in a combo box? 2
Spell Check specific fields on a subform 2
List subform items on main form 2
Access Daily Entry with multiple entries per field 0
Help with linking a main form's combobox value to the subform 4
Yes/No in a combobox wierdness 8
Update Table via Code 3

Back
Top