Creating the switchboard manager

[mushmoom]

I have got about six tiffernt tables and like to creat a switchboard to control them form switch need help

 

[Gastrifitis]

Well, that's a big topic. Basically you need to create a form with buttons or the like, and for the OnClick event for each button you need to set the event (or macro) that opens the appropriate form. Then go to tools, startup... and in the upper right you choose your new switchboard form as the thing to start with. If there's a specific problem you have doing this, well, specify.

 

[mushmoom]

Thanks mate will try that

 

[SydneyGeek]

Have you tried using the built-in Switchboard Manager, or doesn't that give you what you want?
Tools | Database Utilities | Switchboard Manager.
Pros: Quick to set up if your needs aren't too complex. You can have multiple pages controlled from a main page. You can open forms and queries, launch reports, or run macros or SQL code.
Cons: Limit is 8 items per page. You don't get control over the layout. If you have many reports / forms / tables to control, you will need plenty of buttons just for switching between pages.

Down the track, a custom toolbar may do the job better -- far more flexible and unobtrusive.

Denis