How? Follow-up question - Tina help please!

[Terri]

Hi,

I asked this question on 5/18/2005:

When a user checks a box on a form, I want to change another control to not
updatable. More specifically, it is giving the user to specifically limit
(or identify criteria or range of data) or to select a check box to "select
all". If the box is checked, it won't give the user the option to do the
other - selecting a specific range of data.

I received an answer from Tina -

Action: SetValue
Item: [MyTextBoxName].[Enabled]
Expression: Not[MyCheckboxName]

I need additional help on this one.

I went in and made the suggestions above (per Tina) and Access came back
with the error -

"You can't assign a value to this object.
*The object may be a control on a read-only form.
*The object may be on a form that is open in Design view.
*The value may be too large for this field.

I am not sure how to correct this.

I will try and re-word what I am trying to do:

Layout as such:
[Check box ] [Combo Box] to [Combo Box]

If the check box is selected, it should select all values possible that are
given in the combo box selection. (Also, if the check box is selected, it
should not give the user the option to use the combo boxes either.)

If the check box is not selected, then the user can use the combo boxes to
specify a range of data.

Help please, how can I get this to work in Access?

 

[Ken Snell [MVP]]

This line:
Expression: Not[MyCheckboxName]

should be:
Expression: Not [MyCheckboxName]

 

[tina]

as Ken said, and as i posted on 5/18, the correct macro settings are

Action: SetValue
Item: [MyTextBoxName].[Enabled]
Expression: Not [MyCheckboxName]

did you replace "MyTextBoxName" and "MyCheckboxName" with the correct names
of the your textbox and checkbox controls, as i instructed?

other than above, i don't know what to tell you. i normally do this in VBA,
not macros, so i tested the macro before posting the settings; it worked in
my A2000 db running in A2003. if you're using an older version of Access,
such as A97, that might be the problem; i don't know, but maybe Ken could
help us out on that issue if it's relevant.

hth