Form Coding??

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

Guest

I am trying to establish a code to make 6 "bound" check boxes (A,B,C etc)
appear as checked when an different "unbound" checkbox (Full) is checked on a
form named sensitising.

I have tried this

If Sensitising.Full = True Then
Sensitising.A = True
Sensitising.B = True
Sensitising.C = True
Sensitising.D = True etc

Else

Sensitising.A = False
Sensitising.B = False
Sensitising.C = False
Sensitising.D = False

End If

But it doesn't work (Runtime Error 424) Would grouping the A, B,C,D etc make
it easier?

I understand the concept (the "math") behind coding but not the actual
individual codes i.e. Boolean, Dim, acTextBox etc etc) Is there anywhere on
the internet where I can learn more or is it too big a task??
 
If Sensitising is the name of your form and it is the Active form, the lack
of object qualification is causing the problem. Change all occurances of
Sensitising. to Me.
 
Grouping Checkboxes is normally done with an Option Group, thus the
CheckBoxes (or Option Buttons) are not stored individually as Yes/No values,
but a numeric value for the Group, and only one of the boxes can be checked
at any given time. But, you can have multiple Yes/No Fields and can set
them programatically and Klatuu has offered advice on that.

Larry Linson
Microsoft Access MVP
 
Back
Top