Group: microsoft.public.access.forms
From: "Douglas J. Steele"
Date: Friday, October 19, 2007 1:17 PM
Subject: Re: Code for Checkbox and Listbox

I suspect the error actually said macro and macro group...

Try doing a compile of your application (on the Debug menu when you're in
the VB Editor) and see whether it complains about anything.

If that doesn't turn up any culprits, make a back-up of your application and
try decompiling it. Tony Toews has instructions at
http://www.granite.ab.ca/access/decompile.htm

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


"scott04" wrote in message
news:37E4DF53-902A-4A09-9AEE-DA13ABFB63C3@microsoft.com...
> Douglas,
> This did help however when i check on the bottom star to add a new record
> for some reason i get this message:
> "Mircosoft office access can't find the marco '.'
> The marco (or its marco group) doesn't exist, or the marco is new but
> hasnt
> been saved. Note that when you enter the marcogroupname.marconame syntax
> in
> an argument, you must specifiy the name the marco's marco group was last
> saved under."
> Any thoughts on what this may mean? Thanks.
>
> "Douglas J. Steele" wrote:
>
>> Private Sub Form_Current()
>>
>> Me.List38.Enabled = Nz(Me.checkbox3, False)
>>
>> End Sub
>>
>> or
>>
>> Private Sub Form_Current()
>>
>> Me.checkbox3 = False
>> Me.List38.Enabled = Me.checkbox3
>>
>> End Sub
>>
>>
>>
>> --
>> Doug Steele, Microsoft Access MVP
>> http://I.Am/DougSteele
>> (no e-mails, please!)
>>
>>
>> "scott04" wrote in message
>> news:25252042-48D1-4B46-A9DD-4FEF9AF336A5@microsoft.com...
>> >I forgot to put the error:
>> > Invalid use of null and then it takes me to:
>> >
>> >
>> > Private Sub Form_Current()
>> >
>> > Me.List38.Enabled = Me.checkbox3
>> >
>> > End Sub
>> >
>> > "scott04" wrote:
>> >
>> >> This code works for what i am trying to do but if i go to create a new
>> >> record
>> >> i receive the following error:
>> >>
>> >> I have but the code in the afterupdate and form_current. Is that the
>> >> correct place? The code i put is
>> >>
>> >> Me.List38.Enabled = Me.checkbox3
>> >>
>> >> "fredg" wrote:
>> >>
>> >> > On Fri, 19 Oct 2007 06:03:01 -0700, scott04 wrote:
>> >> >
>> >> > > Hi everyone,
>> >> > > I am creating a database for another manager and am trying to
>> >> > > figure
>> >> > > out the
>> >> > > proper code for a scenerio. I have checkbox1 and list38. I would
>> >> > > like the
>> >> > > list38 only be enabled if checkbox1 is checked off. I know the
>> >> > > code
>> >> > > would
>> >> > > start something like this:
>> >> > > If checkbox1 = True Then
>> >> > > Can someone please assist. Thank you.
>> >> >
>> >> > Doe the Check box AfterUpdate event, as well as the Form's Current
>> >> > event:
>> >> >
>> >> > Me![List38.Enabled = Me![Checkbox1]
>> >> >
>> >> > You might want to think about naming your controls with more
>> >> > descriptive names. Combo1 or List38 doesn't let any future developer
>> >> > know what it's purpose is.
>> >> > --
>> >> > Fred
>> >> > Please respond only to this newsgroup.
>> >> > I do not reply to personal e-mail
>> >> >
>>
>>
>>