Display a List of Data for a Record on Report....URGENT

[buee04]

PLEASE HELP! Deadline is this Friday!!

Thanks.

This is more of a design problem, but I will need help with the technicalities too. I have some 6 fields that are automatically on the report as default. Then I have 10 textboxes reserved for the fields that the user chooses to display. The user selects the different fields from frmReportSelect, which is pretty much a listbox that you can have multiple selections and a preview report button. The record source for the listbox is qryAll, which is all of the fields that I want to display from different tables.

I have one main table, tblJobs, which has a good number of other tables related to it via ContractNumber. There are 3 tables that have a one to many relationship with tblJobs: tblFlexComp, tblFirmsInvolved, and tblEquipSold.

So if the user chooses to display the field FLEX COMPONENT (which is from tblFlexComp), I want to be able to display all of the different components under that ContractNumber.

But because the textboxes cannot resize and reposition automatically and there is no specific textbox for each field, I don't know how to display the 3 fields if they are selected. I need to keep the report to one page too.

Please! Any help or suggestion is greatly appreciated!!

 

[CosmoKramer]

Did you try to insert these 3 optional fields as a subreport?

 

[buee04]

Hey kramer, thanks for looking.

Yes, I tried making 2 of the fields as 2 subreports and wasn't looking right on the report, so I didn't go through with it. But it looks like it's the only way.

Do you have any design suggestions?