I have a MS Access 2003 question relating to checkboxes. I have a checkbox
on a form titled "grieved". I would like to use this item to make the next
textbox "grievancenum" grayed out / unavilable is the checkbox is not
selected and available if it is selected. Any help on this would be really
appreciated.

On Thu, 16 Feb 2006 11:07:31 -0800, Todd wrote:

> I have a MS Access 2003 question relating to checkboxes. I have a checkbox
> on a form titled "grieved". I would like to use this item to make the next
> textbox "grievancenum" grayed out / unavilable is the checkbox is not
> selected and available if it is selected. Any help on this would be really
> appreciated.

Code the check box AfterUpdate event:

Me![grievancenum].Enabled = Me![CheckBoxname]

Place the same code in the Form's Current event.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

I tried your suggestion and got the following error message


The expression On Current you entered as the event property setting produced
the following error: The object doesn’t contain the Automation object ‘Me.’.

"fredg" wrote:

> On Thu, 16 Feb 2006 11:07:31 -0800, Todd wrote:
>
> > I have a MS Access 2003 question relating to checkboxes. I have a checkbox
> > on a form titled "grieved". I would like to use this item to make the next
> > textbox "grievancenum" grayed out / unavilable is the checkbox is not
> > selected and available if it is selected. Any help on this would be really
> > appreciated.
>
> Code the check box AfterUpdate event:
>
> Me![grievancenum].Enabled = Me![CheckBoxname]
>
> Place the same code in the Form's Current event.
> --
> Fred
> Please respond only to this newsgroup.
> I do not reply to personal e-mail
>

Did you simply type that expression into the box labelled On Current for the
form?

What you need to do is select [Event Procedure] from that box, and hit the
ellipsis (...) to the right.

You'll be taken into the VB Editor, with the lines

Private Sub Form_Current()

End Sub

Type that code between those two lines.

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


"Todd" <(E-Mail Removed)> wrote in message
news:118ADB1B-4C1D-4C1D-96A3-(E-Mail Removed)...
>I tried your suggestion and got the following error message
>
>
> The expression On Current you entered as the event property setting
> produced
> the following error: The object doesn't contain the Automation object
> 'Me.'.
>
> "fredg" wrote:
>
>> On Thu, 16 Feb 2006 11:07:31 -0800, Todd wrote:
>>
>> > I have a MS Access 2003 question relating to checkboxes. I have a
>> > checkbox
>> > on a form titled "grieved". I would like to use this item to make the
>> > next
>> > textbox "grievancenum" grayed out / unavilable is the checkbox is not
>> > selected and available if it is selected. Any help on this would be
>> > really
>> > appreciated.
>>
>> Code the check box AfterUpdate event:
>>
>> Me![grievancenum].Enabled = Me![CheckBoxname]
>>
>> Place the same code in the Form's Current event.
>> --
>> Fred
>> Please respond only to this newsgroup.
>> I do not reply to personal e-mail
>>

thanks... it works perfectly now.

"Douglas J. Steele" wrote:

> Did you simply type that expression into the box labelled On Current for the
> form?
>
> What you need to do is select [Event Procedure] from that box, and hit the
> ellipsis (...) to the right.
>
> You'll be taken into the VB Editor, with the lines
>
> Private Sub Form_Current()
>
> End Sub
>
> Type that code between those two lines.
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no private e-mails, please)
>
>
> "Todd" <(E-Mail Removed)> wrote in message
> news:118ADB1B-4C1D-4C1D-96A3-(E-Mail Removed)...
> >I tried your suggestion and got the following error message
> >
> >
> > The expression On Current you entered as the event property setting
> > produced
> > the following error: The object doesn't contain the Automation object
> > 'Me.'.
> >
> > "fredg" wrote:
> >
> >> On Thu, 16 Feb 2006 11:07:31 -0800, Todd wrote:
> >>
> >> > I have a MS Access 2003 question relating to checkboxes. I have a
> >> > checkbox
> >> > on a form titled "grieved". I would like to use this item to make the
> >> > next
> >> > textbox "grievancenum" grayed out / unavilable is the checkbox is not
> >> > selected and available if it is selected. Any help on this would be
> >> > really
> >> > appreciated.
> >>
> >> Code the check box AfterUpdate event:
> >>
> >> Me![grievancenum].Enabled = Me![CheckBoxname]
> >>
> >> Place the same code in the Form's Current event.
> >> --
> >> Fred
> >> Please respond only to this newsgroup.
> >> I do not reply to personal e-mail
> >>
>
>
>

The final solution that works ended up looking something like this:

Private Sub Form_Load()

Me![Grievance Num].Enabled = False

End Sub


And the after update property on the Grieved checkbox:


Private Sub Grieved_AfterUpdate()

Me![Grievance Num].Enabled = Me![Grieved]

End Sub


It is now working perfectly.

Todd




"Todd" wrote:

> thanks... it works perfectly now.
>
> "Douglas J. Steele" wrote:
>
> > Did you simply type that expression into the box labelled On Current for the
> > form?
> >
> > What you need to do is select [Event Procedure] from that box, and hit the
> > ellipsis (...) to the right.
> >
> > You'll be taken into the VB Editor, with the lines
> >
> > Private Sub Form_Current()
> >
> > End Sub
> >
> > Type that code between those two lines.
> >
> > --
> > Doug Steele, Microsoft Access MVP
> > http://I.Am/DougSteele
> > (no private e-mails, please)
> >
> >
> > "Todd" <(E-Mail Removed)> wrote in message
> > news:118ADB1B-4C1D-4C1D-96A3-(E-Mail Removed)...
> > >I tried your suggestion and got the following error message
> > >
> > >
> > > The expression On Current you entered as the event property setting
> > > produced
> > > the following error: The object doesn't contain the Automation object
> > > 'Me.'.
> > >
> > > "fredg" wrote:
> > >
> > >> On Thu, 16 Feb 2006 11:07:31 -0800, Todd wrote:
> > >>
> > >> > I have a MS Access 2003 question relating to checkboxes. I have a
> > >> > checkbox
> > >> > on a form titled "grieved". I would like to use this item to make the
> > >> > next
> > >> > textbox "grievancenum" grayed out / unavilable is the checkbox is not
> > >> > selected and available if it is selected. Any help on this would be
> > >> > really
> > >> > appreciated.
> > >>
> > >> Code the check box AfterUpdate event:
> > >>
> > >> Me![grievancenum].Enabled = Me![CheckBoxname]
> > >>
> > >> Place the same code in the Form's Current event.
> > >> --
> > >> Fred
> > >> Please respond only to this newsgroup.
> > >> I do not reply to personal e-mail
> > >>
> >
> >
> >