Concatenate Values to Specify Form Name 1

[noelville]

Hello, I want to save lines of code by specifying the form name as a concatenation of two values: a constant TAB + a number.

I have a main form and multiple subforms: e.g. Tab01, Tab02 ....
Is it possible to refer to the appropriate subform this way rather than hardcode Tab01 or Tab02 ... e.g.

instead of:
Me.Tab01.Form.Filter = "PageName"

define strIX as "01" or "02" ...

Me.["Tab" & "'" & strIX & "'"].Form.Filter = "PageName"
Thanks Alex

 

[alvechurchdata]

The Controls collection can accept a string as an index:

[TT]
Me.Controls("Tab01")
[/TT]

so you should be able to use your concatenated values
[TT]
controlName = "Tab" & strIX
Me.Controls(controlName).Form.Filter = "PageName"
[/TT]

Geoff Franklin

http://www.alvechurchdata.co.uk