Repeat header row of subform on Next Page? 1

[rccline]

My report has a subreport that is multiple pages long.
How do I get the header row of my subreport to repeat on the next page?

Thanks.

Robert

 

[dhookom]

In your subreport design view, create a new top sorting and grouping level. Set the field/expression of this level to a constant like:
=1
Display the Group Header for this section. Set the =1 Group Header
Repeat Section: Yes


Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[rccline]

Sorry. I don't understand.
I can create a new group level... that gives me options of different fields to sort on. I guess you would set the sort to the same field that the master and child fields sort on.

I also do not understand setting the field expression =1

Thanks.

Robert

 

[dhookom]

You don't have to select a field. This is similar to the Control source of a text box. As I stated, just type in
=1
If you prefer, you can use:
="Robert"
Any expression that is a constant.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]