Add 10 blank records after a sub report MS Access

[ManieAc]

have a report that I wish to add 10 blank fields to the end of the sub report.
The blank fields will be used for updating or adding of records on a paper form to be turned in to be updated in the Access07 data base.

I have created a record from “labels” and added them to the footer area of the report but they do not print.
Also I have tried a similar method with “Rectangles”. This way dose print them, but with a large gap between the sup report.
How do I get rid of this blank space between?
I am new to all this so this may be something very simple!

[nico5038]

have a report that I wish to add 10 blank fields to the end of the sub report.
The blank fields will be used for updating or adding of records on a paper form to be turned in to be updated in the Access07 data base.

I have created a record from “labels” and added them to the footer area of the report but they do not print.
Also I have tried a similar method with “Rectangles”. This way dose print them, but with a large gap between the sup report.
How do I get rid of this blank space between?
I am new to all this so this may be something very simple!

Hi ManieAc,

I've removed the duplicate thread for you.

In general I solve a "problem" like this by using a UNION query for the subreport that's adding 10 empty rows from a "dummy" table.
Thus the report processing is "standard" and only a query change and a table is needed for the solution.

Getting the idea ?

Nic;o)

[ManieAc]

Hi ManieAc,

I've removed the duplicate thread for you.

In general I solve a "problem" like this by using a UNION query for the subreport that's adding 10 empty rows from a "dummy" table.
Thus the report processing is "standard" and only a query change and a table is needed for the solution.

Getting the idea ?

Nic;o)

Hello Nico, Thank you for your reply.

I think I will need a little more instruction. I will state the facts,
I am very new to Access and this is my first DB using VBA. Bottle and or Spoon feeding my be required.{:-)

[nico5038]

OK, step wise:
1 Ceate a copy of your table used for the subform
2 Place 10 empty rows with just the "key" being the highes value
(Say OrderLine to be the table then use e.g. lines 90 / 99 as the line number
3) Change the subreports query into:
[code=sql]
select * from tblOrderDetails
UNION
select * from tblOrderDetails 10
[/code]
4) Run the report

When you're having trouble, just give the problem and the stepnumber.

Nic;o)