I'm not very VBA or SQL literate so I'm trying to figure a way to make this
form work.

I created a form out of a word document. It populates bookmarks and
references with data from a SQL database. The form is static. It allows up to
9 employees names, addresses, etc to display.

For example:
Laura Smith
15 Street Princeton, NY 08696
US citizen

Larry Kole
58 Rd New York, NY 90012
UK citizen

Jen  Reilly
40 Avenue Miami, FL 10012
FR citizen

So there are 3 employees that print per page. So I end up having 3 pages
each everytime.

My problem is that I don't always have 9 employees everytime. Sometimes I
may just have one which would
only need to print on page 1 or four employees which would print on 2 pages.

Is there any way to write a macro that will prevent pages from displaying
and printing depending the
the number of employees. So if there are 3 employees then page 1 will print.
If there are 4 to 6 employees then  page 2 will print.
If there are more than 6 employees pages 1 thru 3 will display and print.

Any suggestions? Many thanks Microsoft experts