Report on form that contains multiple Sub Forms (1 Viewer)

scouser

Registered User.
Local time
Today, 12:39
Joined
Nov 25, 2003
Messages
767
Hi. I have a form 'Display Details' that contains 8 sub forms. The user populates the sub-forms by selecting either a UserID or ComputerID from 2 combos in the form header. The form then displays Computer Details / User Details / Installed Hardware / Installed Software etc...I would like to report what is on screen in a single report? So the user clicks a button and all information for the current record being viewed is displayed within a single report.

How might I achieve this?

Many Thanks,
Phil.

Update: I tried dropping the queries that create the form onto a report. I added a button to the main form then on click called macro 'Open Report' that contained the line:
[ComputerID]=[Forms]![DISPLAY_COMPUTER_FORM]![ComputerID]
 
Last edited:

Users who are viewing this thread

Top Bottom