[AccessD] error in code

Hello,

thanks for those who responded.

Me.Controls and getting rid of the spaces did the trick.


Pedro Janssen




----- Original Message -----
From: "Bryan Carbonnell" <carbonnb at sympatico.ca>
To: "Access Developers discussion and problemsolving"
<accessd at databaseadvisors.com>
Sent: Monday, April 19, 2004 12:46 AM
Subject: Re: [AccessD] error in code


> On 19 Apr 2004 at 0:17, Pedro Janssen wrote:
>
> > why isn't this part of a code not working
> >
> > for i  = 1 To 9
> > If "chb" & i & "c31") = True Then
> >     .Item("Code" & i).Value = "**     geen code"
> > End If
> > Next i
>
> Pedro,
>
> I am assuming that chb* are checkboxes. If so, try:
>
> If me.controls("chb" & i & "c31") = True Then
>
> You also have a closing ) on the ofiginal If Then line.
>
> --
> Bryan Carbonnell - carbonnb at sympatico.ca
> I am a nobody, and nobody is perfect; therefore, I am perfect.
>
>
> --
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>