Button on report

[Xenix]

Can anyone help me with this:
In Access I can still use the toolbox to put a command button on the the report, but when you try to press it in view mode the display switches to print preview as it does in report preview mode

How can I get the button to work, all it will do is email that report?

Thanks
Mike

 

[Rich]

Use a custom menu bar.

 

[Xenix]

Thank you Rich,

but the problem is I want to use the command:
DoCmd.SendObject acSendReport, "QuotationEMail", , Me.[Emailaddress], , , "Honda Connectors Ltd.", , True

and I don't know how to do it? I want it to email a report which is controlled by giving the quote number to the report and then is displays that record, but this command don't pass the quote number like a standard search so only works for the first record only

the search code is:

DoCmd.OpenReport "QuotationEMail", acPreview, "", "

=[Forms]![Quotation]!

"

Can anyone advise me?