HELP--how do you select fields show in report based on opened form?

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hi,
I try to create report (ReportCollection) from 3 tables:
1. tblCollections (has 16 fields)
2. tblAgent (has 6 fields)
3. tblNotes (has 23 fields)
I created a query that contains all fields in this 3 tables. (total field 45
fiels)
I have a loaded/open form call frmCollection. User will key in information
in frmCollection which contains: cboAgent, optgrpFileType, Bill Cycle
parameter, and 9 options to sort the report (optSort).
I create a "view report" button so on click even will open ReportCollection.

In the reportCollection design view, on property control I pass the value
from frmCollection to ReportCollection for example:
=[Forms].[frmCollectionsDashboard].[txtFromBillCycle]

On ReportCollection detail section, I only want to show related information
around 4 to 6 fields filtered based on frmCollection.

QUESTIONS:
1. How do I select fields for each sort?
I try to use sqlSetup, then Me.Recordsource = sql Setup (contains sql
statements for each case)
but the details section show blank. (I've use debug.print sql and sql
statement is correct)

2. In details section do I need to create unbound textboxes? or what do I
need to do?

I greatly appreciate any help, thanks in advance.

Ges

--
Ges Khu
Geskhu@xxxxxxxxx
Access Beginner

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-reports/200808/1

.

Quantcast