PrintOut action problem

  • Thread starter Thread starter ME
  • Start date Start date
M

ME

I have a command button on a form that activates a
macro. I'm trying to program it to print out the report
for a single record (out of 1200 records in the table).

When I hit the button, it successfully prints the report
I tell it to (it prompts me for the primary key number
for the record I want to print). But then it also prints
whatever form I happen to be looking at when I hit the
button.

The macro is only two actions, with an OpenReport action
and a PrintOut action.

The OpenReport's Where Condition is:

[Potential Donors]![ContactID]=[Forms]![Potential Donors]!
[ContactID]

"ContactID" is my label the primary key. The PrintOuts'
print range is "selection."

Help!

-ME
 
ME,

Get rid of the printout action in your macro. The open
report action will print you report. The printout action
is printing the active object - your form in this case.

HTH,

Terry
 
Thanks, that helps a bunch.

If you actually read this, can you tell me how I can
change the print settings with the OpenReport action so
that it prints in draft mode?

-ME



-----Original Message-----
ME,

Get rid of the printout action in your macro. The open
report action will print you report. The printout action
is printing the active object - your form in this case.

HTH,

Terry
-----Original Message-----
I have a command button on a form that activates a
macro. I'm trying to program it to print out the report
for a single record (out of 1200 records in the table).

When I hit the button, it successfully prints the report
I tell it to (it prompts me for the primary key number
for the record I want to print). But then it also prints
whatever form I happen to be looking at when I hit the
button.

The macro is only two actions, with an OpenReport action
and a PrintOut action.

The OpenReport's Where Condition is:

[Potential Donors]![ContactID]=[Forms]![Potential Donors]!
[ContactID]

"ContactID" is my label the primary key. The PrintOuts'
print range is "selection."

Help!

-ME


.
Click to expand...
.
Click to expand...
 
Back
Top