How do I use a record as a page header?

  • Thread starter Thread starter Guest
  • Start date Start date
I generally store this information in a table. You can then create a
subreport based on the "organization" table in the header of other reports.
You could also use domain aggregate functions in control sources of text
boxes like:

=DLookup("OrgName","tblOrganization")

There are other methods.
 
You could use a Group Header instead of a Page Header, set the property
'ForceNewPage' to 'BeforeSection'.
 
Thank you I will try both of your ideas.
Dave

Joanthan said:
You could use a Group Header instead of a Page Header, set the property
'ForceNewPage' to 'BeforeSection'.
Click to expand...
 
Sorry for the delay getting back to you. This will show you how new I am to
some of Access. I do not understand what you are telling me. How can I create
a sub report? Where would you put this domain aggregate function? Can you
recomend a guide (book or training site) that would help?
Dave
 
A subreport is like any other report except that it is placed as a subreport
control on a main report. You can actually drag a report (your subreport) in
the database window onto a section of a main report while the main report is
in design mode.
 
Back
Top