Darren DICK
darrend at nimble.com.au
Mon Jun 5 09:21:33 CDT 2006
Hi All
Can't quite get the syntax right on this one
I am looping through an SQL statement
The Statement produces sequential numbers (as integers) 1,2,3,4,5 etc
e.g...
rs!ProfileID will = 1 on the first loop
rs!ProfileID will = 2 on the second loop etc etc until EoF
So far so good...
Based on those numbers I wanna loop thought the recordset the number of times
the dot recordcount allows
and I want to make controls on the form - that end with the looped Recordset
integer - visible or not
Code above and below my air code works fine - all the declarations are OK
Air Code.....
dim strControlName as string
For intX = 1 To rs.RecordCount
strControlName = "txtProfile" & intX.
Me(strControlName).Visible = True
Next intX
Anyone know what the correct syntax for the air code is??
Many thanks
Darren