Form will only print to one printer

[netrusher]

Below is the code I have on a print command button on my
form. No matter what printer I have selected the form will
only print to a certain printer? It used to print to
the selected printer and now just to one printer. Any advice
or suggestions? I have added a new command button to print
current form but to no avail.

On Error GoTo Err_print_Click

    DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
    DoCmd.PrintOut acSelection

Exit_print_Click:
    Exit Sub

Err_print_Click:
    MsgBox Err.Description
    Resume Exit_print_Click

 

[SeeThru]

Check the setup in report designer. I think there is a 'specific priter' setting in there somewhere - cna't seem to find it at the moment.

SeeThru
Synergy Connections Ltd - Uk Telemarketing and Telesales Services and
Synergy Mobile Solutions - UK Mobile phones, land lines and call packages

 

[genomon]

Open the report in design view. Go to file|page setup|page.

Illegitimi non carborundum.

 

[missinglinq]

I don't think the report designer setup will help, as the OP states he's printing a form. In Design View for the form goto

File - Page Setup - Use Specific Printer

then use the browse button to select the desired printer.

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!

 

[kzutter]

There was a bug in the RC version of Access 2007 that caused reports to reset to the default printer. This was fixed in SP2.

The original poster did not mention which version he/she was using, but this may be helpful.

 

[missinglinq]

I think you have to have SP2 and the subsequent hotfix installed, but once again, the OP states that he's trying to print a form, not a report, although his description does really sound like the 2007 report printing bug. It'd be nice to get some feedback from the OP.

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!

 

[TheAceMan1]

How are ya netrusher . . .

Since your attempting to print a single record perhaps the following will do:

How to Print a Single Record from a Form in a Report

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]