Hi, I'm not sure if I can do this.
I have a Main Form (Main Table)with
SubformA (TableA)
SubformB (TableB)
SubformC (TableC)
They are all connected with a Record Number. The form is saved as a report.
Each subform is set up with a specific number of rows (TableA is 5, TableB is 8, and TableC is 6). This is because the form is an application that due to regulations must only have those specific number of lines on it. However, the user may actually have 6 rows for TableA and 10 for TableB. They can fill in the additional info but what I need is for the report to print two separate pages that look the same with the Main Table Info at the top, then SubformA, then SubformB, then SubformC. I have tried changing different properties but, I always end up with two SubformA's, then two SubformB's...Is there some way to prevent this from happening? Thanks!
I have a Main Form (Main Table)with
SubformA (TableA)
SubformB (TableB)
SubformC (TableC)
They are all connected with a Record Number. The form is saved as a report.
Each subform is set up with a specific number of rows (TableA is 5, TableB is 8, and TableC is 6). This is because the form is an application that due to regulations must only have those specific number of lines on it. However, the user may actually have 6 rows for TableA and 10 for TableB. They can fill in the additional info but what I need is for the report to print two separate pages that look the same with the Main Table Info at the top, then SubformA, then SubformB, then SubformC. I have tried changing different properties but, I always end up with two SubformA's, then two SubformB's...Is there some way to prevent this from happening? Thanks!
