How To Launch a Dashboard from my switchboard

[astange]

I am using a dashboard builder by open gate software and need to launch them from my switchboard, i am not sure how to make this happen.

[ranman256]

set the switchboard table field: Command = 3 (form browse)
[argument]= frmDashboard (or whatever the form name is)

Helpful item:
I built a table of the commands, tSbCommands
I set the switchboard table field: Command
the LOOKUP type = combo
rowsource = tSbCommands

This way just pick the command visually .

SwCmd	Action
0	Header of form
1	Switchboard
2	FormAdd
3	FormBrowse
4	Report
5	Customize Switch
6	Exit
7	Run Macro
8	Run Code
9	Table

[astange]

Still having trouble figuring out exactly where to put fLoadDashboard(1801) to open the dashboard from my switchboard. tried putting it in the switchboard tbl but it gives the error incorrect frm name...

[astange]

where would i insert the VB launch code fLoadDashboard(1801)?

[astange]

Please Help!

[astange]

any ideas on how to accomplish this?

[Minty]

I'm not sure what you are referring to with fLoadDashboard(1801)?

Is that really the name of your form? I would strongly advise taking out those brackets if it is, as I doubt Access will parse that name being passed into 99% of functions correctly.