Check box enabling other fields in a form

[wideasleep]

I have a form that I'm working on that I would like to be able to use a check box to enable other selections in the form. Otherwise I would like to have them as non selectable.

I have a checkbox called work order and I am using a lookup table called work order number and a date field. The checkbox will enable both of these.

Thanks for any help

[JKing]

I recommend setting the Enabled property of the two controls to no in design view so when the form first opens the user is forced to click the check box to enable the controls.

The code to switch enabled property back and forth should be done in the click event of the check box.

Private Sub chkCheckBox_Click()
If chkCheckBox = True Then
Control1.Enabled = True
Control2.Enabled = True
Else
Control1.Enabled = False
Control2.Enabled = False
End If
End Sub
 

Control1 and Control2 being the items you want to enabled or disable and chkCheckBox would be your check box name.

JKing

[wideasleep]

Great, I will try it out

Thanks again!

[wideasleep]

Unfortunately that isn't working, neither is enabling. Any ideas? Everything is entered in right. I even recreated it in a seperate form.

[JKing]

What are the two controls you're trying to enable?

And could you post me a snippet as well.

[wideasleep]

One is a number field (WorkOrderNumber) and the other is a drop down box (WorkOrder). Oh and the Checkbox is (CkeckBox)

[wideasleep]

Private Sub Checkbox_Click( )
If Checkbox = True Then
WorkOrderNumber.Enabled = True
WorkOrder.Enabled = True
Else
WorkOrderNumber.Enabled = False
WorkOrder.Enabled = False
End If
End Sub

[JKing]

So when you run the form and click the check box nothing at all happens? And when you uncheck the box nothing happens either?

[wideasleep]

Yes that's correct, and as I've said I re-created it in another form to try it out

[wideasleep]

Scratch that, I got it to work! I appreciate your assistance. All your code was right I had one thing I screwed up on in Access 2007. Sorry

[JKing]

Great to hear! I was really stumped for a moment trying to figure out what was wrong. Glad it's working though.

[wideasleep]

Now do you know anything about subforms? Cause now that I go to use this it enables it on every record in the subform and when I go to enter data in it gets recorded on every record I have! HELP!

[wideasleep]

Oh by the way this is a continuous subform

[JKing]

Not too sure about this one. Might want to try posting that question as another thread.

[MMcCarthy]

Oh by the way this is a continuous subform

This is known as conditional formatting. You can't do this using code on a continuous form. Open the form in form view and set focus on the control you want to enable. Now go to the Format menu and select Conditional formatting. This should enable you to set the control to enabled on your conditions.