Editable field only based on another field

Can you help me out with understanding this a little more. I entered this:

Me![TextBox].Enabled = Me![Checkbox]

in the After Update under properties of my checkbox control, of course
substituting the TestBox name I wanted to enable for TestBox and the same for
the Checkbox. When I go back to the form view and click the check box I get
an error saying the the Macro doesn't exist. Am I supposed to build a macro
or am I entering something wrong.
--
julostarr


"John W. Vinson" wrote:

On Fri, 26 Sep 2008 11:05:41 -0700, "Jeff Boyce"
wrote:

If I wanted to enable a textbox based on whether a checkbox were checked,
I'd probably add something like the following in the checkbox's AfterUpdate
event:

Me!TextBox.Enabled = Me!Checkbox

.... and also the Form's Current event, to handle existing records, I'd
suggest.
--

John W. Vinson [MVP]

If you entered that directly in the space following the label for
AfterUpdate in the properties, Access will try to find a macro with that
name.

To be more specific, you will need to create an AfterUpdate event procedure
and enter that expression in the event procedure.

Regards

Jeff Boyce
Microsoft Office/Access MVP

"julostarr" wrote in message
...
Can you help me out with understanding this a little more. I entered
this:

Me![TextBox].Enabled = Me![Checkbox]

in the After Update under properties of my checkbox control, of course
substituting the TestBox name I wanted to enable for TestBox and the same
for
the Checkbox. When I go back to the form view and click the check box I
get
an error saying the the Macro doesn't exist. Am I supposed to build a
macro
or am I entering something wrong.
--
julostarr


"John W. Vinson" wrote:

On Fri, 26 Sep 2008 11:05:41 -0700, "Jeff Boyce"
wrote:

If I wanted to enable a textbox based on whether a checkbox were
checked,
I'd probably add something like the following in the checkbox's
AfterUpdate
event:

Me!TextBox.Enabled = Me!Checkbox

.... and also the Form's Current event, to handle existing records, I'd
suggest.
--

John W. Vinson [MVP]

Well, I never could get the Me![TextBox].Enabled = Me![Checkbox] to work, but
I played around with an IF Expression and it worked for me. If the checkbox
is checked it goes to the following field to allow editing and if it is
unchecked then the next field is uneditable and tabbing through it skips that
field. The code I used goes as follows:

Private Sub Ctl401_k_Participant_AfterUpdate()
If Me![401(k)Participant] = True Then
Me![401(k)%].Enabled = True
Else
Me![401(k)%].Enabled = False
End If
End Sub

I'm still learning about VBA, but this IF conditional express worked for me
in this situation. I was expecting the field in question to be grayed out
when it was uneditable, but it is fine this way.

If you have any tips for me or can help me understand this a little more
that would be great. If not thank you so much for you help.


--
julostarr


"Jeff Boyce" wrote:

If you entered that directly in the space following the label for
AfterUpdate in the properties, Access will try to find a macro with that
name.

To be more specific, you will need to create an AfterUpdate event procedure
and enter that expression in the event procedure.

Regards

Jeff Boyce
Microsoft Office/Access MVP

"julostarr" wrote in message
...
Can you help me out with understanding this a little more. I entered
this:

Me![TextBox].Enabled = Me![Checkbox]

in the After Update under properties of my checkbox control, of course
substituting the TestBox name I wanted to enable for TestBox and the same
for
the Checkbox. When I go back to the form view and click the check box I
get
an error saying the the Macro doesn't exist. Am I supposed to build a
macro
or am I entering something wrong.
--
julostarr


"John W. Vinson" wrote:

On Fri, 26 Sep 2008 11:05:41 -0700, "Jeff Boyce"
wrote:

If I wanted to enable a textbox based on whether a checkbox were
checked,
I'd probably add something like the following in the checkbox's
AfterUpdate
event:

Me!TextBox.Enabled = Me!Checkbox

.... and also the Form's Current event, to handle existing records, I'd
suggest.
--

John W. Vinson [MVP]

I don't know why the expressioin didn't work ... did you get an error
message? Did you insert a breakpoint in the code so you could step through
it one statement at a time and see what values were being returned?

Congratulations on a solution!

Regards

Jeff Boyce
Microsoft Office/Access MVP


"julostarr" wrote in message
...
Well, I never could get the Me![TextBox].Enabled = Me![Checkbox] to work,
but
I played around with an IF Expression and it worked for me. If the
checkbox
is checked it goes to the following field to allow editing and if it is
unchecked then the next field is uneditable and tabbing through it skips
that
field. The code I used goes as follows:

Private Sub Ctl401_k_Participant_AfterUpdate()
If Me![401(k)Participant] = True Then
Me![401(k)%].Enabled = True
Else
Me![401(k)%].Enabled = False
End If
End Sub

I'm still learning about VBA, but this IF conditional express worked for
me
in this situation. I was expecting the field in question to be grayed out
when it was uneditable, but it is fine this way.

If you have any tips for me or can help me understand this a little more
that would be great. If not thank you so much for you help.


--
julostarr


"Jeff Boyce" wrote:

If you entered that directly in the space following the label for
AfterUpdate in the properties, Access will try to find a macro with that
name.

To be more specific, you will need to create an AfterUpdate event
procedure
and enter that expression in the event procedure.

Regards

Jeff Boyce
Microsoft Office/Access MVP

"julostarr" wrote in message
...
Can you help me out with understanding this a little more. I entered
this:

Me![TextBox].Enabled = Me![Checkbox]

in the After Update under properties of my checkbox control, of course
substituting the TestBox name I wanted to enable for TestBox and the
same
for
the Checkbox. When I go back to the form view and click the check box
I
get
an error saying the the Macro doesn't exist. Am I supposed to build a
macro
or am I entering something wrong.
--
julostarr


"John W. Vinson" wrote:

On Fri, 26 Sep 2008 11:05:41 -0700, "Jeff Boyce"

wrote:

If I wanted to enable a textbox based on whether a checkbox were
checked,
I'd probably add something like the following in the checkbox's
AfterUpdate
event:

Me!TextBox.Enabled = Me!Checkbox

.... and also the Form's Current event, to handle existing records,
I'd
suggest.
--

John W. Vinson [MVP]

I did get an error message with the other code before. I'm not sure if it
was because I did't put it in right or what. Anyway, I tried it again and it
worked now. I do have another question though. I notice that with either of
these solutions. The field that I wanted disabled/enabled with relation to
the checkbox is only disabled after I check the box and then uncheck it
again. Is there a way to make it disabled until the checkbox is checked Yes
and then disabled again if the checkbox is unchecked? I realize that the
After Update makes these expressions apply only After Update of course, but I
tried to put these solutions in the Before Update and it didn't change
anything.

I'm also thinking about trying to do something similar with a list/dropdown
box. I would like to make one choice from the list box enable one field and
disable another and do the oposite with another choice from the same
list/dropdown box and maybe a third choice to disable both fields. It seems
like maybe If...Then...Else could be used in some way I'm just unsure exactly
how.

P.S. If my question is confusing let me know and I'll try to rephrase it.
--
julostarr


"Jeff Boyce" wrote:

I don't know why the expressioin didn't work ... did you get an error
message? Did you insert a breakpoint in the code so you could step through
it one statement at a time and see what values were being returned?

Congratulations on a solution!

Regards

Jeff Boyce
Microsoft Office/Access MVP


"julostarr" wrote in message
...
Well, I never could get the Me![TextBox].Enabled = Me![Checkbox] to work,
but
I played around with an IF Expression and it worked for me. If the
checkbox
is checked it goes to the following field to allow editing and if it is
unchecked then the next field is uneditable and tabbing through it skips
that
field. The code I used goes as follows:

Private Sub Ctl401_k_Participant_AfterUpdate()
If Me![401(k)Participant] = True Then
Me![401(k)%].Enabled = True
Else
Me![401(k)%].Enabled = False
End If
End Sub

I'm still learning about VBA, but this IF conditional express worked for
me
in this situation. I was expecting the field in question to be grayed out
when it was uneditable, but it is fine this way.

If you have any tips for me or can help me understand this a little more
that would be great. If not thank you so much for you help.


--
julostarr


"Jeff Boyce" wrote:

If you entered that directly in the space following the label for
AfterUpdate in the properties, Access will try to find a macro with that
name.

To be more specific, you will need to create an AfterUpdate event
procedure
and enter that expression in the event procedure.

Regards

Jeff Boyce
Microsoft Office/Access MVP

"julostarr" wrote in message
...
Can you help me out with understanding this a little more. I entered
this:

Me![TextBox].Enabled = Me![Checkbox]

in the After Update under properties of my checkbox control, of course
substituting the TestBox name I wanted to enable for TestBox and the
same
for
the Checkbox. When I go back to the form view and click the check box
I
get
an error saying the the Macro doesn't exist. Am I supposed to build a
macro
or am I entering something wrong.
--
julostarr


"John W. Vinson" wrote:

On Fri, 26 Sep 2008 11:05:41 -0700, "Jeff Boyce"

wrote:

If I wanted to enable a textbox based on whether a checkbox were
checked,
I'd probably add something like the following in the checkbox's
AfterUpdate
event:

Me!TextBox.Enabled = Me!Checkbox

.... and also the Form's Current event, to handle existing records,
I'd
suggest.
--

John W. Vinson [MVP]

Given that this new question is somewhat different, you'd get more eyes (and
brains) working on it if you posted it as a new question, rather than
burying it so far down in the current thread.

Regards

Jeff Boyce
Microsoft Office/Access MVP

"julostarr" wrote in message
...
I did get an error message with the other code before. I'm not sure if it
was because I did't put it in right or what. Anyway, I tried it again and
it
worked now. I do have another question though. I notice that with either
of
these solutions. The field that I wanted disabled/enabled with relation
to
the checkbox is only disabled after I check the box and then uncheck it
again. Is there a way to make it disabled until the checkbox is checked
Yes
and then disabled again if the checkbox is unchecked? I realize that the
After Update makes these expressions apply only After Update of course,
but I
tried to put these solutions in the Before Update and it didn't change
anything.

I'm also thinking about trying to do something similar with a
list/dropdown
box. I would like to make one choice from the list box enable one field
and
disable another and do the oposite with another choice from the same
list/dropdown box and maybe a third choice to disable both fields. It
seems
like maybe If...Then...Else could be used in some way I'm just unsure
exactly
how.

P.S. If my question is confusing let me know and I'll try to rephrase it.
--
julostarr


"Jeff Boyce" wrote:

I don't know why the expressioin didn't work ... did you get an error
message? Did you insert a breakpoint in the code so you could step
through
it one statement at a time and see what values were being returned?

Congratulations on a solution!

Regards

Jeff Boyce
Microsoft Office/Access MVP


"julostarr" wrote in message
...
Well, I never could get the Me![TextBox].Enabled = Me![Checkbox] to
work,
but
I played around with an IF Expression and it worked for me. If the
checkbox
is checked it goes to the following field to allow editing and if it is
unchecked then the next field is uneditable and tabbing through it
skips
that
field. The code I used goes as follows:

Private Sub Ctl401_k_Participant_AfterUpdate()
If Me![401(k)Participant] = True Then
Me![401(k)%].Enabled = True
Else
Me![401(k)%].Enabled = False
End If
End Sub

I'm still learning about VBA, but this IF conditional express worked
for
me
in this situation. I was expecting the field in question to be grayed
out
when it was uneditable, but it is fine this way.

If you have any tips for me or can help me understand this a little
more
that would be great. If not thank you so much for you help.


--
julostarr


"Jeff Boyce" wrote:

If you entered that directly in the space following the label for
AfterUpdate in the properties, Access will try to find a macro with
that
name.

To be more specific, you will need to create an AfterUpdate event
procedure
and enter that expression in the event procedure.

Regards

Jeff Boyce
Microsoft Office/Access MVP

"julostarr" wrote in message
...
Can you help me out with understanding this a little more. I
entered
this:

Me![TextBox].Enabled = Me![Checkbox]

in the After Update under properties of my checkbox control, of
course
substituting the TestBox name I wanted to enable for TestBox and the
same
for
the Checkbox. When I go back to the form view and click the check
box
I
get
an error saying the the Macro doesn't exist. Am I supposed to build
a
macro
or am I entering something wrong.
--
julostarr


"John W. Vinson" wrote:

On Fri, 26 Sep 2008 11:05:41 -0700, "Jeff Boyce"

wrote:

If I wanted to enable a textbox based on whether a checkbox were
checked,
I'd probably add something like the following in the checkbox's
AfterUpdate
event:

Me!TextBox.Enabled = Me!Checkbox

.... and also the Form's Current event, to handle existing records,
I'd
suggest.
--

John W. Vinson [MVP]