Form command button to start report wizard?

[superblades]

Hi im trying to find a way of starting the access report wizard from a button on a form, anyone know how to do this?

Thanks

Superblades

 

[macca the hacke]

You can create a custom toolbar, that just contains icon to open a new report. This will start the report wizard.
You can then show / hide the custom toolbar using :
DoCmd.ShowToolbar ("toolbarname"), acToolbarYes (to show) and
DoCmd.ShowToolbar ("toolbarname"), acToolbarNo (to hide)

 

[boblarson]

This one is easier and you can put it on your command button:

DoCmd.RunCommand acCmdNewObjectReport

Or, if you are using a Macro (as opposed to VB Code):

ACTION: RunCommand
COMMAND: NewObjectReport