Help Setting No Copies And Recordno Follow

0
Avatar
Legacy Poster

Hi Guys

 

I need a simple form where the user will enter 4 test values, a start tray no and end tray no.

 

So if they enter start no of 5 and end of 10, it should calculate the no of labels is 6 and then show tray no 5 on the first label, 6 on the second, etc.

 

Attached is my attempt

 

I'm trying to set Copies to the calculation result and then use this to control the no of labels and also increment TrayNo for each label (starting from StartTrayNo)

If is Set 5-10, TrayNo increments every time, but always starts from 1. How do I get it to start from StartNo (txtTray field value)?

 

It always prints 9 records instead of end - start + 1. Anyone know why this is happening?

 

Can anyone tell me where I'm going wrong?

 

Thanks

 

mark

1 comments

0
Avatar
Ian Cummings
Moderator
Comment actions Permalink

Please sign in to leave a comment.