Trying to use a Frame to group a set of Controls

[scott56hannah]

Hi,

I am using Access 2007 for the first time and I am trying to group a set of
controls (ie textbox, combo, lists) in a frame....and then trying to use the
frame.enabled property to enable and disable those controls in one
statement...

But I cannot seem to get the Frame within the Access form to recognise the
controls that are within it.....

How can I acheive this with Access....in Excel I have been able to do this..

Thanks
Scott

 

[Arvin Meyer [MVP]]

Frames can only hold checkboxes, radio buttons, and toggle buttons. You can
simulate a control array by naming your controls similarly, then looping
through them.

Try: Text1, Text2, Text3

Then use:

Dim i As Integer

For i = 1 To 3
Me.(Text & i).Visible = False
Next i