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.)
