Switchboard Help

[Trinabeana]

Hi all,

I am somewhat new to access, and am just learning VB and Macros. I have a form that has a drop down list that you can select all of the workshop #s. Once selected, the rest of the fields generate themseleves. There are about 4 fields on this form. Drop down for workshop, leader name, workshop name, and date of workshop. Then I have links at the bottom of the form that (once a workshop is selected, you can click on buttons such as, run report, edit existing workshop, create new workshop, enter evaluations. However, all the buttons are linked to whatever is selected in the drop down. So If I select workshop # 12f-103, then click the "enter evaluations" button, it will take me to another form that is directly linked to workshop #12f-103.

What I want to do, is take all those buttons at the bottom and put them on the switchboard. So the only button at the bottom of the form will say "Go to switchboard", only after the person has selected a workshop # though. But I can't seem to do that? What can I do?

 

[JHB]

What is the problem? To go to the switchboard or stop people going to the switchboard before they have selected a workshop?

 

[Trinabeana]

Hello. Thanks for the reply.
The problem is that I want all of the links associated on the select form, on the switchboard, instead of the form itself. So that on the select form, there was a button that said go to switchboard...once on switchboard...all the buttons that are currently on the select form at the moment, that are associated with the dropdown...will now be on the switchboard instead of all the buttons on the form.

So say I wanted to edit a workshop. First I would have to go to the select form, then click the drop down arrow, select the workshop #, again, the rest of the fields will populate on their own (i,e., workshop name, leader, date)......What I currently have is the button on the select form saying edit workshop...So when you click the button, whatever workshop # you selected in your dropdown, another form will open with that workshop already in there, so all you have to do is edit it. Now, instead of buttons like that being on the select form itself. I was wondering if I could have one button, "go to switchboard button" and from there, have all my buttons, but they have to be associated with the dropdown form...

 

[JHB]

Then use DoCmd.OpenForm and OpenArgs

DoCmd.OpenForm "YourswitchboardFormName", , , , , , Me.TheNameOfTheControlWhereYouSelectTheWorkshop

And then on the SwitchBoardForm you get the value from the Me.TheNameOfTheControlWhereYouSelectTheWorkshop so.

Me.OpenArgs

Let's say the value of Me.TheNameOfTheControlWhereYouSelectTheWorkshop is "12f-103" then will Me.OpenArgs show "12f-103"