Re: Active, Inactive textboxes

Piet's code assumes you have two text boxes (one named txt1, one named
txt2) 
and that you want txt1 to be enabled when the check box (named MyCheckBox)

is checked and disabled when it's not checked. and that you want txt2 to
be 
disabled when the check box is not checked and enabled with it is. Change 
the names of MyCheckBox, txt1 and txt2 as appropriate.

However, there's a mistake in the code.

It should simply be

Sub MyCheckBox_AfterUpdate()
  Me.txt1.Enabled=Me.MyCheckBox
  Me.txt2.Enabled=Not Me.MyCheckBox
End Sub

Check boxes are either True or False. There's no reason for a variable
named 
Checked.

-- 
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"AccessDB" <scl1974@[EMAIL PROTECTED]
> wrote in message 
news:72c193d1-430e-43cb-8041-30284a43e569@[EMAIL PROTECTED]
> in the afterupdate of your checkbox, set the Enabled property of the
> relevant textboxes.
>
> Sub MyCheckBox_AfterUpdate()
> Me.txt1.Enabled=(MyCheckBox=Checked)
> Me.txt2.Enabled=Not (MyCheckBox=Checked)
> End Sub

I'm new to coding so in your code Me.txt1.Enabled=(MycheckBox=Checked)
- is the txt1 the name of my textbox on my form? If so, then what is
the second line of code for?