Urgent Help needed .Main Window - Manager and Staff Windows

[Skroof]

Hi all ,

I need help with my db please,



Can you please help create a main window as per attached picture(MainWindow.jpg),
I need only 1 form with only 2 buttons – manager and staff – you click on manager then it list a menu only relevant to manager and you click on staff and it list only menu relevant to staff.
Also i need the Appointments Query1 report to use drop down buttons so i can choose a month that i want, not text box as it is now.

Thanking you in advance.

Regards
Skroof

[June7]

You have switchboard created but it is not the setup you want? Then build it to suit your needs. Plenty of tutorials on how to do this. Search Access Help or Google: Access switchboard tutorial

Personally, I never use the switchboard wizard. I also don't use macros, only VBA. I build a normal form with command buttons and VBA code event procedures.

Reports are not really intended to be interactive. Never tried what you want. I have users input/select criteria on a form and the report references the form control for parameter.

[Skroof]

Please delete this thread for me, I cant find the delete function. Thanks

[June7]

Why? Threads are only deleted if they violate forum rules (spam, duplication, insulting) and a moderator/administrator must do it.