Use Visual Basic to force a page break in a form if condition is met?

[thirty4d]

Hello anyone,

I have a form that is grouped by UPPER and LOWER (values)
Turrets (name of the control). I also have a page header in my form where all records with UPPER values to print on page 1 and LOWER values to print on page 2.

You will probably suggest why not use a report instead. Sounds great but unfortunately I cant use a report because in my form I also have unbound control that have to be data-entry by the end-users. I thought reports are just read only.

I am trying to accomplish 2 things.

1) To display the data on page 2 if there is a group of records that have LOWER values. and

2) How can I hide page 2 if there is no group of records with LOWER values?

Can this be done?

Thanks in advance