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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top