I have a main menu that will display a dropdown control if they select a button on that form. I have the following code when the menu form opens, lost_focus, and loads:
combrgs_and_Accounts.Visible = False
When they click on a button it displays the dropdown control. All of that works fine. When they click on an item in the dropdown, it goes to another form - that works. When they click on the "go to new menu button" I coded
Private Sub btnClose_Click()
On Error GoTo btnClose_Click_Err
DoCmd.Echo True, ""
DoCmd.Close , ""
DoCmd.OpenForm "frm_New_Menu", acNormal, "", "", , acNormal
btnClose_Click_Exit:
Exit Sub
btnClose_Click_Err:
MsgBox Error$
Resume btnClose_Click_Exit
End Sub
But when the "new menu form" opens, the dropdown displays as well as the label for the dropdown. What other event should I use to make sure the dropdown does not display.
Also, does the "label" also only display when the control does and do I need to code to make that property not visible?
Thanks for any help!
combrgs_and_Accounts.Visible = False
When they click on a button it displays the dropdown control. All of that works fine. When they click on an item in the dropdown, it goes to another form - that works. When they click on the "go to new menu button" I coded
Private Sub btnClose_Click()
On Error GoTo btnClose_Click_Err
DoCmd.Echo True, ""
DoCmd.Close , ""
DoCmd.OpenForm "frm_New_Menu", acNormal, "", "", , acNormal
btnClose_Click_Exit:
Exit Sub
btnClose_Click_Err:
MsgBox Error$
Resume btnClose_Click_Exit
End Sub
But when the "new menu form" opens, the dropdown displays as well as the label for the dropdown. What other event should I use to make sure the dropdown does not display.
Also, does the "label" also only display when the control does and do I need to code to make that property not visible?
Thanks for any help!