Variable use before .Value

[wallaseawez]

I am trying to substitue the 1 below for a Variable in my code

vol = Forms!frm_3rdSchd.att1.Value

but can't seem to figure out how to do it

vol = Forms!frm_3rdSchd.att & regNum & .Value

gives 'Invalid or unqualified reference'

 

[pbaldy]

Try this, which is off the top of my head:

vol = Forms!frm_3rdSchd.Controls("att" & regNum).Value

 

[wallaseawez]

cheers pbaldy, this works a treat - knew it would be simple solution