Is this possible from Print Preview?

  • Thread starter Thread starter Jim
  • Start date Start date
J

Jim

I'm wondering if this is possible - with a report open in Print Preview to a
specific page, open a Form and display the record currently displayed in
Print Preview? If not, would it be possible from Layout view?
 
It would be quite difficult to do this in Print Preview.

Essentially, you would need to write code that uses the Print event of the
Detail section to assign the primary key value to a public variable. This
variable would therefore contain the key value for the last record that
fitted onto the page you are viewing, so you could use this variable to
either Filter your form, or FindFirst in its RecordsetClone and set its
Bookmark (unless NoMatch, which could happen if the form is filtered.)

Since you talk about Layout view, you must be using A2007. You could
therefore use Report view to make the record clickable (or add a command
button) to OpenForm with a filter, or FindFirst in its RecordsetClone (as
discussed above.)
 
Back
Top