Continuous Form using multiple queries

[LimitedTech]

I have a form that we use to track when we pay people.
Until now we have just had a "Total Deductions" field. Now we need to give a list of the individual deductions. I have created a separate table (TblDeductions) to handle this.
The main table is (TblMasterSales).
The field "SalesNumber" is common between the two tables.
Currently I have a form that produces a list of unpaid sales they haven't been paid for based on the SalesmanID.

It looks similar to this:
Salesman ID Date Sales Number Gross Amount Deductions Net Amount
John001 01/01/08 56235 $1000.00 $200.00 $800.00

John001 01/02/08 56250 $800.00 $100.00 $700.00

The form is in a continuous display.
I would like to go below each record and have to detailed information displayed from TblDeductions (in red).

Salesman ID Date Sales Number Gross Amount Deductions Net Amount
John001 01/01/08 56235 $1000.00 $200.00 $800.00
Deductions details:
01/02/08 Personal loan $75.00
01/03/08 Advance for fuel $100.00
01/04/08 Cash Advance $25.00


John001 01/02/08 56250 $800.00 $100.00 $700.00
Deductions details:
01/03/08 Personal loan $100.00

I have tried using a subform but it will not let me do that with the continuous form.
I also just tried adding the line in the query but then I end up with 3 (or however many deductions there are) separate records on my form.

Thanks

 

[MajP]

faq702-5860
will explain how to set up two continous subforms. If this is for display purposes uses a report and look at sorting and grouping

 

[LimitedTech]

Maybe I didn't do something right but I can only get this to work on a single views main form and continuous subform. Access gives an error message and will not let me change the view on the main/master form to continuous.

 

[Remou]

You cannot have a continuous form with a subform. Depending on what you are doing, a subdatasheet may suit.

http://office.microsoft.com/en-us/access/HP052362171033.aspx?pid=CH063645611033

However, it may be best to look at a different approach, such as pop-up forms in the double-click event, single forms with a listbox for navigation, or a treeview.

 

[LimitedTech]

Yea, I am pretty much seeing that. Working on Pop-up work around now!