created serial number in report control form

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.
 
Back
Top