M
MissJane11 via AccessMonster.com
I have a main form which holds the general information about a finance
contract (i.e Contract Number, Financier, Paid in full date etc)
I then have a subform which holds the income received for each contract.
I want to have a report that shows the contracts that have not received any
income for a period of time.
The Main form is not the problem, what is is the subform. If I don't have
any income received yet obviously all fields in the subform remain blank, and
this is what I am trying to pick up.
I was wondering if there was anyway to create a blank record in the subform
on execution of the contract number in the main form
Any help is appreciated
contract (i.e Contract Number, Financier, Paid in full date etc)
I then have a subform which holds the income received for each contract.
I want to have a report that shows the contracts that have not received any
income for a period of time.
The Main form is not the problem, what is is the subform. If I don't have
any income received yet obviously all fields in the subform remain blank, and
this is what I am trying to pick up.
I was wondering if there was anyway to create a blank record in the subform
on execution of the contract number in the main form
Any help is appreciated