how i can hide column using option group

[BrOkEn_iCe]

i need some help in using option group to hide a column in a subforum
i try any code but all my try has been faild

i try this code but i don't know what is the wrong

   Select Case Frame28.Value
      Case 1
         Forms![formSubform]![column1].ColumnHidden = True
      Case 2
         Forms![formSubform]![column2].ColumnHidden = True
      Case 3
         Forms![formSubform]![column3].ColumnHidden = True
      Case 4
         Forms![formSubform]![column4].ColumnHidden = True
      Case 5
         Forms![formSubform]![column5].ColumnHidden = True
   End Select
End Sub

thnks all

 

[DCrake]

Simple Software Solutions

Have you employed a Me.Repaint or Me.Refresh after your Select case?

 

[BrOkEn_iCe]

yes but the error say there r error in the code

Forms![formSubform]![column1].ColumnHidden = True

i don't know why

 

[DCrake]

Simple Software Solutions

Here is the full code you need

Forms("MainForm")("SubForm")!ControlName.ColumnHidden = True
DoEvents
Me.Repaint

You may also need a reset option to display all hidden fields.

CodeMaster:

 

[BrOkEn_iCe]

thnks man that code work
thnks alot