chancer1967
Excel jockey
- Local time
- Today, 13:07
- Joined
- Mar 31, 2004
- Messages
- 28
I have a database for credit control and within this there are tables for invoices, credits and payments.
As a reconciliation tool I have created a form that gives activity totals for a given month.
The top of the form has two text boxes for year and month (they will become combos at some point), and beneath that are 3 subforms, each of which is linked to a query which gives the total invoices (or credits or payments) for the month and year specified.
I then have an update button that the user presses to refresh the 3 subforms when the date is changed.
It all works very well, but there is one small annoyance:
In some months there are no credits. In these months the subform for credits vanishes. I would rather it stay there and show a zero.
Is there a parameter in the subform that I need to change for this to happen?
Thanks
As a reconciliation tool I have created a form that gives activity totals for a given month.
The top of the form has two text boxes for year and month (they will become combos at some point), and beneath that are 3 subforms, each of which is linked to a query which gives the total invoices (or credits or payments) for the month and year specified.
I then have an update button that the user presses to refresh the 3 subforms when the date is changed.
It all works very well, but there is one small annoyance:
In some months there are no credits. In these months the subform for credits vanishes. I would rather it stay there and show a zero.
Is there a parameter in the subform that I need to change for this to happen?
Thanks