created serial number in report control form

[Guest]

I created a random serial no. in a text box (Text box 89) in an Access 97
control form. I would like to reuse that number thoughout the report. Can I
use the printing variable I created that prints out to display elsewhere on
the report? If I just copy the text box, it recalculates the serial number
on each page.

 

[Allen Browne]

If the first box is named (say)
txtSerialNum
then in later sections of the report you can use this in the ControlSource
of your text box:
=[txtSerialNum]

The idea of printing a random number that won't be the same next time you
run the report does not sound very appealing though.