You might try dragging the report from the database window to the desktop.
That will create a shortcut which will open the report for printing. You can
also set a reference to the database that has the report you want to open,
then write a standard module sub to open the report. You can now call that
sub for the first database. The code is the same as opening a report
normally, it's just put in a Standard Module:
Public Sub OpenContractors()
DoCmd.OpenReport "rptContractors", acPreview
End Sub
Then in the calling database, a single line in the click event of a button:
Sub OpenRpt_Click()
OpenContractors
End Sub
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access