Problem making a label visible in a subform! URGENT - Please HELP!!!

[maisam]

Hi guys,

I have a form (frmMain) which contains 3 subforms and they are being set to visible at different stages of application run (depending on the options selected).

In subfrm_Main_options i have 3 buttons, clicking on 'Job Review' will make the subfrm_Search visible. In the subfrm_Search i have 2 labels, 'View Jobs' and 'View Report' and I only want the 'View Jobs' to be visible!

I have tried setting the visible property of this label to False in the subfrm_Main_Options but its giving me an error (saying the form subfrm_Search is closed or does not exist in the database!). I also tried using a Global Variable (ViewJobs - declared in module mdlPublicVars) and set it to True once the 'Job Review' is clicked in the subfrm_Main_Options form, and then look at this in subfrm_Search and then display the correct label. However after trying to put this code in various events such as, On Open, On Got Focous, On Activation, ... i didnt get the result i wanted!

Can any1 please help me out with this. I would be really grateful!

PS. The buttons appearing on the form are placed on the frmMain, I did that to see if it appears on the main form but they must be in subfrm_Search!

The database is attached!

Thanks, Maisam

 

[edtab]

In the OnLoad event of the subform_search, place this code:

Private Sub Form_Load()
Me.lblViewReport.Visible = False
End Sub