Format a report and new pages

[Stu]

Hi.

I'm very new to Access/Visual Basic so please forgive my ignorance.

The application that I'm attempting to construct is a simple customer
quotation database. Each quote has a quote number which is unique. Each
customer may have several quotes.

I'm trying to produce a report based on a simple query. The query goes along
the lines of...

When the user selects a customer from a combobox, return all the quotes
associated with that customer.

This works and returns the info that I'm expecting. The problem arises when
I'm trying to format the output to a report.

The report is formatted like so...

Customer
Quote Num
Items within the quote

This is currently being displayed as...

(Page header)
Customer
Quote Num (1)
(Detail)
Quote item 1 (from quote 1)
Quote item 2 (from quote 1)
Quote item 1 (from quote 2)
Quote item 2 (from quote 2)
Quote item 1 (from quote 3)
Quote item 2 (from quote 3)
etc...

This continues until a new page is reached.

What I would like to do is only have one quote per page and just the items
associated with that quote on the same page. When the next quote is
displayed this should be on a new page. As you can see, currently I'm only
having one quote number listed in the Page header and then all of the quote
items for all of the quotes listed in the Detail.

This is what I would like...

(Page header)
Customer
Quote Num (1)
(Detail)
Quote item 1 (from quote 1)
Quote item 2 (from quote 1)

New page.

(Page header)
Customer
Quote Num (2)
(Detail)
Quote item 1 (from quote 2)
Quote item 2 (from quote 2)

New page.

(Page header)
Customer
Quote Num (3)
(Detail)
Quote item 1 (from quote 3)
Quote item 2 (from quote 3)

New page.

I'm sure this is a simple dilemma, but I would really appreciate some
assistance.

Thanks,

Stu.

 

[Les]

Stu,
You need to go to properties for your Quote Num Header
section. Change "Force New Page" to Before Section.