Keeping Report Preview on top

  • Thread starter Thread starter Robin Chapple
  • Start date Start date
R

Robin Chapple

I have a routine that when a member is terminated a letter is prepared
in Report Preview, the member is flagged as terminated, the form is
closed and reopened with only active members.

I would like the report to stay on top, be printed and when closed the
form to be viewed.

Is this possible?

Thanks,

Robin Chapple
 
Robin,

First of all, it probably isn't necessary to close the form and then
open again. Are you doing this simply so the terminated member is no
longer shown on the list? If so, you could just use the Requery method.

In any case, why don't you print the report before doing anything to set
the focus back to the form? If you have to close/open/requery/whatever
the form, before printing the report, I am pretty sure you could put a
DoCmd.SelectObject line in the code to bring the report preview to the
front again.
 
Steve,
Robin,

First of all, it probably isn't necessary to close the form and then
open again. Are you doing this simply so the terminated member is no
longer shown on the list? If so, you could just use the Requery method.
Click to expand...

Yes that is the object. Where do I code the Requery?

The cursor is in a field of a subform.
In any case, why don't you print the report before doing anything to set
the focus back to the form? If you have to close/open/requery/whatever
the form, before printing the report, I am pretty sure you could put a
DoCmd.SelectObject line in the code to bring the report preview to the
front again.
Click to expand...

May I consider that after I get the Requery working?

Robin
 
Hi Robin,

I don't know anything at the moment about your code, or where the code
is being called from, so I can't really comment. If I guess correctly
that the code is running from an event on the form, just insert this
line into the code...
Me.Requery
 
Back
Top