Subforms and Report

[ychousa]

Hi. I have 5 subforms in a main form (frmMain) and a report.

Main form is bound to Main table and each subforms has its bound tables. The child tables and the main table are connected by an ID.(DetID)

This form is for calculating expenses for a show. The 5 subforms represent each category of expenses. Each subform has subtotals and the main form has TOTAL for all the subforms.

My problem is that when I print a report, if there is any subform that was left without any input, the TOTAL is empty.

The subforms are connected by DetID to main form and if there are inputs for all the subforms, the report shows total without any problem.

The join properties for a query for the report are set to "Include all the fiels from Main table..."

Anybody has an idea what is wrong?

If you need further details. please let me know.

thanks.

John

 

[faeryfyrre]

use the nz() function in the ControlSource of your Total textBox to tell it to replace null value (which you get when the subform is empty) with a zero.

Alec Doughty
Doughty Consulting P/L

"Life's a competition. Play hard, but play fair"