Subform visibility
Hello,
I have a main form (Main_Menu) and 2 sub forms (Main_DLMP and Main_DeptView). In the main menu I have 2 labels that act as menu. I have click events on both these labels. I want to make one visible, and the other not visible. But I struggling with this. These are the 2 events I have for each of the labels in my main form.
This is the event on the first label. As default Main_DLMP visibility is set to True and DLMP_DeptView is set to False.
Forms![Main_Menu].[Main_DL
Forms![Main_Menu]![Main_DL
Forms![Main_Menu]![Main_De
This is the event on the second lablel
Forms![Main_Menu].[Main_De
Forms![Main_Menu]![Main_De
Forms![Main_Menu]![Main_DL
I am getting an error on the second label... Cannot set focus.
I have a main form (Main_Menu) and 2 sub forms (Main_DLMP and Main_DeptView). In the main menu I have 2 labels that act as menu. I have click events on both these labels. I want to make one visible, and the other not visible. But I struggling with this. These are the 2 events I have for each of the labels in my main form.
This is the event on the first label. As default Main_DLMP visibility is set to True and DLMP_DeptView is set to False.
Forms![Main_Menu].[Main_DL
Forms![Main_Menu]![Main_DL
Forms![Main_Menu]![Main_De
This is the event on the second lablel
Forms![Main_Menu].[Main_De
Forms![Main_Menu]![Main_De
Forms![Main_Menu]
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
You have to make it visible BEFORE you can set focus.
So reverse the order so it becomes:
And you should hide the subform object, not the form, so it then becomes:
So reverse the order so it becomes:
Forms![Main_Menu]![Main_DeptView].Form.Visible = True
Forms![Main_Menu].[Main_DeptView].SetFocus
Forms![Main_Menu]![Main_DLMP].Form.Visible = False
And you should hide the subform object, not the form, so it then becomes:
Forms![Main_Menu]![Main_DeptView].Visible= True
Forms![Main_Menu].[Main_DeptView].SetFocus
Forms![Main_Menu]![Main_DLMP].Visible = False
Normally Labels don't need Focus...
What you probably need is that the Labels are unassociated with any controls. To check it just right clicks -->Properties..check if Events are displayed...if its blank ..then the easy way is to make a copy of the Label delete the old Label..rename the New label to match the old name and you should be fine
Also for Visiility
What you probably need is that the Labels are unassociated with any controls. To check it just right clicks -->Properties..check if Events are displayed...if its blank ..then the easy way is to make a copy of the Label delete the old Label..rename the New label to match the old name and you should be fine
Also for Visiility
Me.Lbl1.Visible = Not Me.Lbl2.Visible
Premium Content
You need an Expert Office subscription to comment.Start Free Trial