[AccessD] Refering to a control with a variable

You can actually get away with just:

Controls("txtbox" & Trim(Str(IntA)))

-- 
Stuart

On 20 May 2010 at 13:15, Stuart McLachlan wrote:

> Me.Controls.Item("txtbox" & Trim(Str(IntA)))
> 
> (the "Me." is optional)
> 
> -- 
> Stuart
> 
> 
> On 19 May 2010 at 19:17, Dale_Anne Kalsow wrote:
> 
> > Good Evening,   If I have a control named txtbox1 and a variable of intA
> > with a value of 1, does anyone know how to refer to the control in VBA
> > with with something simular to "txtbox" & intA?   Thanks!   Dale 
> > 
> > 
> >       
> > -- 
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> > 
> 
> 
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>