brudderman
Technical User
I have several subforms (unbound) based on different queries in the detail section of a main form. The fields are formatted with borders an aligned so that the print looks like a grid. In the footer of each subform I have a total based on a formula like this: =Nz(DSUM("amount", "qryMoneyItemized",0)).
The problem is with a subform whose query returns no records. When I run the subform by itself, the grids show, as does a total of 0, and that's the way I want it to appear. But when it's embedded in a main form, only a blank page appears.
What can I do to get this subform to show up even when no records are returned by the query?
THanks!!
Brudderman
The problem is with a subform whose query returns no records. When I run the subform by itself, the grids show, as does a total of 0, and that's the way I want it to appear. But when it's embedded in a main form, only a blank page appears.
What can I do to get this subform to show up even when no records are returned by the query?
THanks!!
Brudderman