I want print button to print to default printer depending on user

I have a print button (Command12) on a form (frmStaffNames) that
activates the following event

Private Sub Command12_Click()
DoCmd.OpenReport "SummaryTest", acPrintAll
DoCmd.Close acForm, "frmStaffNames"
End Sub

For some reason when any user clicks the button the report
(SummaryTest) prints at the same printer regardless of user. I want
the report to print to the users default printer, which is different
for each user.

Do I need to add more code?

"robnsd" wrote in message
...
I have a print button (Command12) on a form (frmStaffNames) that
activates the following event

Private Sub Command12_Click()
DoCmd.OpenReport "SummaryTest", acPrintAll
DoCmd.Close acForm, "frmStaffNames"
End Sub

For some reason when any user clicks the button the report
(SummaryTest) prints at the same printer regardless of user. I want
the report to print to the users default printer, which is different
for each user.

Do I need to add more code?

You need to split your database and put a copy of the front-end on each
user's workstation. Running as you are not only makes what you want
difficult, but you will eventually corrupt your data. Before you split it,
change it in each report's design view so it prints on the default printer.
Then after splitting, it will print on each user's default machine.

Splitting the database:
http://www.granite.ab.ca/access/splitapp/overview.htm
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com