How use an MS access field both in form detail and page footer

[Guest]

I have a form consisting of several sections :
form header (screen only), page header (print only), detail (screen and
print), page footer (print only), form footer (screen only).
The detail section gives an overview of a person's data (name, address, ..).
The page footer contains a formal agreement that must be signed before
sending back the hardcopy version for the archives. Some datafields (name,
....) are used both in the detail and in the page footer.

This works fine when printing a single form : the same data appears in the
top section (detail) and the bottom section (page footer) of the printed
report.
But when printing multiple forms for different people, access jumps to the
next record when commencing the page footer. This results in a printed form
with different names in the top and bottom sections, which is clearly not the
intention.

How do I solve this?

 

[Allan Murphy]

Pieter

Just a thought, Why not put it all in the detail section and layout the
detail section in the required format.

 

[Guest]

You would do better to print a report than a form. You can group reports by
person (in your case) or by any other field. If you put the information
specfic to a person into the group header and/or footer it will appear only
with that person's record. In report properties look for Grp Keep Together,
and in the Detail and/or Group Header properties look for Force New Page.
There are other options, depending on your specific needs.
You can save your existing form as a report, so there is no need to start
all over with the report. You can still use your form as it is for data
entry and editing, but reports are best for printing.

 

[Guest]

Ofcourse reports are better for printing. But my form also serves as input
medium when the completed/corrected and signed hardcopies are returned.
Using a form ensures a common layout on screen and on print, whereas using a
form for the Input and a report for Output requires 2 modifications when
anything needs to be changed.

 

[Guest]

Hi Allan,

The "details" section serves as I/O : printing the current data and allowing
modification when needed.
The "page footer" section contains only a formal statement such as "I,
[Name], confirm that above data ....". This is relevant only for the paper
archives. Moving this to the details section would "overload" the screen
layout, that is already fairly full.

 

[Guest]

It was not obvious from your question that you are aware reports are better
for printing. Have you tried adding a page break to the form?

 

[Guest]

Hi Bruce,

My aim is to have a single printed page containing the personal info in the
top half of the page, and a personalised statement of correctness below.
I don't see how adding a page break would prevent access from jumping to the
next record...

 

[Guest]

In my quick test on one of my own forms it worked, which was why I suggested
it. If there is room on the page after printing one record Access will start
the next record, and the footer will show information for that record even
though none of the fields are visible. If you add a page break directly
below the last control on the form it should ensure that the footer contains
information from the same record as is printed in the details section. It
would have taken less time to try it than to tell me you don't think it would
work.

 

[Guest]

Didn't think I'd hear from you again, but it worked, didn't it?