Report with Form/Subform Data in the Order the User Wants It

D

dalecorey1

I am working on creating a report that will print the form and subform data
in the order the user wants. For example, there are 4 subforms for financial
data and 4 subforms for project related data. The data on the main form has
an index that is common to all the financial and project related data.

The challenge that I have is that the user wants to select a number (via a
combo box) for the main form and subforms that will dictate the order the
data from the form and subforms print on the report.

Has anyone ever designed a report like this? If so, what approach did you
use?

TIA,

Dale Corey
 
Top