Hi Expert,

I am unable to hide subform from masterform using option group. The subform still be displayed in masterform althrough applying Docmd.close... Can you give me a help?

Here is my coding:
Private Sub opt_trans_AfterUpdate()

Dim ctl As Control

    Select Case opt_trans.Value
      Case 1

         DoCmd.Close acForm, "trans_sell subform", acSaveYes
         DoCmd.Requery

      Case 2

         DoCmd.Close acForm, "trans_buy subform", acSaveYes
         DoCmd.Requery

      Case 3

         DoCmd.Requery

   End Select

End Sub


Thanks and Best Regards,
Martin :D:D:D

open your trans_sell subform in design view and do the following

1-Set the AllowEdits property of the subform to Yes
2-Set the OnClick property of the command or toggle button to the following event procedure:

Sub cmdToggle_Click()
   Me![trans_sell subform].Visible = _
      Not Me![trans_sell subform].Visible
End Sub
I hope this helps