Okay, I can't seem to figure out how to limit the # of rows for data entry in a linked subform.

I need to have the entry form bring up 25 rows NUMBERED:
1
2
3
4
5
6
7
8
9
10 and so on to (let's say 25, then add more if needed).

Basically, for each "order", we want ONLY 25 rows numbered during data entry.

So the next "order" brings up again another 25 lines numbered.

I hope I made sense and hope there's a way!!

Without going thru the motions, my thoughts went to maybe setting up your linked subform to be linked to a query with a Left to Right Join (All of a table numbered 1-25 and the [LinkedID] as the other). You could that way show a query with 25 records in it, but blank. Then you could have a command button "ADD MORE FIELDS" that could maybe open the 25 table (form view) to add more.

Really vague I know, but its a shot to start with.

Is there some point to this? What is the problem with numbers being assigned as each row is added. The only way to show the numbers in the subform is to actually create 25 new records and that is not a very good idea.

Thanks! That's something I thought of too but was hoping for something less time consuming. Something that would automatically put 25 rows per "order" number each time an order was created.

Pat - yeah, I know. Management wanted the data entry people to NOT have to worry about numbering the line items as they enter the line details of the "order".

Then generate the number programatically in the BeforeInsert event of the subform.