creating a menu when an access database opens

[radcrow]

I'm a little rusty with Access. I'm creating a database and when it opens I
want a main menu to open either the table or one of the reports.
Help please

 

[Jeff Boyce]

You are describing three different objects.

An Access table stores data, an Access report displays it (for print), and
an Access form (e.g., 'main menu') provides a way for a user to navigate.

You have to create the form (i.e., main menu) and populate it with controls,
and add code to those controls that will do what you want.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[John W. Vinson]

I'm a little rusty with Access. I'm creating a database and when it opens I
want a main menu to open either the table or one of the reports.
Help please

You can (and should) use the Tools... Startup menu item to specify a Form (not
a table or report!!) to open when the database opens.

 

[Barry A&P]

Create a form with the options and controls you want then in access 2003 go
to Tools > Startup > Display Form/Page and select the form you would like to
open on Startup

access 2007 select the Windows icon at top left and then there is an option
like "Database options" inside there is a similar Startup form select option,
but i am not familiar enough to be exact...