How to set variable based on a field in a table 1

[Blitz]

my variable is intNumberRepeats I can do this:<br>intNumberRepeats = Forms!printform!Timestorepeatrecord<br><br>but then it uses whatever record is open in the form and does not change when the report goes to the next record (Im trying to make a report print the # of pages specified in a field, which is not the same for each record) so when my first record needs 3 copies it takes the variable from that and prints 3 copies for every record. So I though that making the variable based on a table instead of a form might work but I dont know how to do it. Thanks for any help.

 

[desiboy]

Define an event on the Detail Format section of the report and then place the code intNumberRepeats = Forms!... there. <p>Sandeep Anand<br><a href=mailto:sandeep@matatechnologies.com>sandeep@matatechnologies.com</a><br><a href=

http://www.matatechnologies.com>Mata

Technologies</a><br>visit

http://www.matatechnologies.com

 

[Blitz]

Didnt work, its still printing the same number of pages for every record.

 

[desiboy]

send me your datbase. <p>Sandeep Anand<br><a href=mailto:sandeep@matatechnologies.com>sandeep@matatechnologies.com</a><br><a href=

http://www.matatechnologies.com>Mata

Technologies</a><br>visit

http://www.matatechnologies.com

 

[Blitz]

I figured it out already. What I did was put the field in my report and made it invisible then just did <br>Me!Timestorepeatrecord eliminating the form completly. Thanks for your help though.<br><br><br>