On Aug 7, 2:38=A0pm, "Douglas J. Steele"
<NOSPAM_djsteele@[EMAIL PROTECTED]
> wrote:
> Piet's code assumes you have two text boxes (one named txt1, one named
tx=
t2)
> 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()
> =A0 Me.txt1.Enabled=3DMe.MyCheckBox
> =A0 Me.txt2.Enabled=3DNot Me.MyCheckBox
> End Sub
>
> Check boxes are either True or False. There's no reason for a variable
na=
med
> Checked.
>
> --
> Doug Steele, Microsoft Access MVPhttp://I.Am/DougSteele
> (no e-mails, please!)
>
> "AccessDB" <scl1...@[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=3D(MyCheckBox=3DChecked)
> > Me.txt2.Enabled=3DNot (MyCheckBox=3DChecked)
> > End Sub
>
> I'm new to coding so in your code
Me.txt1.Enabled=3D(MycheckBox=3DChecked=
)
> - is the txt1 the name of my textbox on my form? If so, then what is
> the second line of code for?
Thank you it works. But how do I have the questions below the Yes/No
question to be Disabled/Inactive until I pick Yes.
Example: First question - Do you have any any siblings?
Second question - How many
I want the "How Many" question to be Disabled/Inactive until Yes is
picked.
Here is my actual code so far:
Sub txtIs_AfterUpdate()
Me.txtApplication.Enabled =3D Me.txtIs
End Sub
What do I need in addition to the code to make this work.
|
