I need to print 30 pre-numbered blank line at end of report

[Dennis]

Hi,

OS: XP Pro with SP3
Access - XP Office Pro - SP3

While I have a lot of programming experience, I am an Access newbie. Thank
you for your patients and your help.

The end of my membership report needs to have 30 pre-numbered blank line at
end of membership report so users can hand write in new members names. The
number is their membership number.

I have manually placed 30 blank text boxes in the report footer. Each of
the 30 text boxes' label contains the underscore text. I programmatically
set the value of each of the 30 text values one at a time. Me.txtMem1 =
lngHighPostNo + 1, Me.txtMem2 = lngHighPostNo + 2, etc.

Is there a more elegant way to accomplish this or is brute force the only way?

Dennis

 

[Allen Browne]

One way would be to create a little table with one field of type number.
Enter 30 records (the numbers 1 - 30.)

Then add a subreport based on this table to the Report_Footer section of
your main report.

 

[Dennis]

Ah, much nicer. Thank you for your help once again.