Hi,
I have 3 nested forms and want to calculate a total on the first
subform (as the form loads)by adding 2 fields from that form
[deposit]+[rental] to a field on the second subform.
Second subform is [transactional subform] and control is Sumpd.
I use this
=[transactiontbl subform].Form!Sumpd+[deppd]+[rentpd]
which works well as long as the transactiontbl subform has records in
it. Problem is this subform will often be empty. I then get error as a
result in my calculated control. Have tried using Iif statements eg
=IIf(Me![transactiontbl
subform].Form.RecordCou nt=0,[deppd]+[rentpd],[transactiontbl
subform].Form!Sumpd+[deppd]+[rentpd])
but as a newbie am surely writing something wrong!
All forms are nested with master/child fields linked. Table
relationships also look OK.
Any help much appreciated.
I have 3 nested forms and want to calculate a total on the first
subform (as the form loads)by adding 2 fields from that form
[deposit]+[rental] to a field on the second subform.
Second subform is [transactional subform] and control is Sumpd.
I use this
=[transactiontbl subform].Form!Sumpd+[deppd]+[rentpd]
which works well as long as the transactiontbl subform has records in
it. Problem is this subform will often be empty. I then get error as a
result in my calculated control. Have tried using Iif statements eg
=IIf(Me![transactiontbl
subform].Form.RecordCou nt=0,[deppd]+[rentpd],[transactiontbl
subform].Form!Sumpd+[deppd]+[rentpd])
but as a newbie am surely writing something wrong!
All forms are nested with master/child fields linked. Table
relationships also look OK.
Any help much appreciated.
Comment