Missing info on reports - clearer I hope

[Maggie23]

I'll try to explain my problem again - hopefully a little clearer.

I have an invoice created in the report format based on a query of two tables. The first table is client names. The second table is amounts due. I have a form for the name table that I input the client basic info. The second table comes from a subform. The main form is pulled from the name table and allows me to pull up the correct client and then enter his amounts due on the subform. One client may have two or three records on the subform of amounts due.

The problem is when I go to run the invoice report the first record of the client prints with the amounts due from the first subform record with the corresponding name. The second record from the subform with the same client name does not print the name at all. The amounts pulled from the 2nd subform record are correct just no client name. Basically it is pulling the client name for the first amount due invoice but not for a 2nd or 3rd invoice.

The question was asked if text boxes for name was set to Hide Duplicates "No". It is.

As I said earlier I am new at this so any suggestions would be helpful. Maybe I am going about this completely wrong!

Thanks for any help.

 

[Pat Hartman]

Does the report's recordsource query work properly when you run it from the query window? Are the table joins correct?

BTW, your forms have nothing to do with the report so including them in the problem description muddies the waters.

Depending on what the report is doing, you may need to split it into a main report and a subreport. Then the query for the main report would be similar to the query for your main form and the query for the subreport would be similar to the query for the subform. The master/child links will keep the subreport in sync with the main report.