View Full Version : Form command button to start report wizard?


superblades
09-29-2006, 04:35 AM
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
09-29-2006, 05:50 AM
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
09-30-2006, 11:36 PM
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