continious form with checkboxes

[EBee]

I am trying to disable some fo the checkboxes on a form that is attached to a query. The form is a continious form with 2 checkboxes and a label next to each checkboxes

Private Sub Form_Load()
If Me.SubZip.Value = "Mariposa" Then
Me.chkMail.Enabled = True
Else
Me.chkMail.Enabled = False
End If


End Sub

In the form load, I wanted to disable a couple of the checkboxes if the label values meets some condition( see code above). The code above is disabling all the check boxes.

help please. . thank you.

 

[PHV]

Standard behaviour for unbound controls in the detail section of a continuous form.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[TheAceMan1]

How are ya EBee . . .

This is typical behavior for an [blue]unbound[/blue] control in a continuous form . . .

See Ya! . . . . . .

 

[EBee]

thank you both . . . the users just have to deal with that i guess. . . moving on to the next feature. .

 

[FastLearnerIThink]

You need to bind the control to the field at one point or another, via code or the control's properties. Check the control source of the control itself. An always unbound control is useless always.

-- Fast Learner, I Think

Here's something to think about. How come you never see a headline like 'Psychic Wins Lottery!'? - Jay Leno

 

[MajP]

This seems to work.

Private Sub chkMail_AfterUpdate()
If Me.subZip = "Mariposa" Then
Me.chkMail = Not Me.chkMail
End If
End Sub