receipts with unbound text box gives Enter Parameter Value

[Chris]

Getting very frustrated. Trying to create a report to act as a receipt for
payment received where the payment is applied against a number of
outstanding dues.

Have a query as the basis of the report with fields Debit, Credit,
TransType, TrandDate, ReceiptNo (grouped on receipt no)
One receipt will consist of one payment (Credit) and numberous debits and
depending on the TransType the debit amount is to be shown in different
boxes. ie: Dues, INI, Fines, WDR etc

I have tried putting unbound text boxs (txtFIN, txtDue, txtINI etc) in the
detail section and then running code on the format event that would check
the transtype and then update the corresponding text field. The totals for
these fields would then be summed in the Report Header or Footer which would
print as the actual receipt. where the fields in the header would have the
control source as =Sum(txtFIN) etc

Keeping getting "Enter Paramenter Vaue" prompt on the unbound text fileds so
obviously not doing something right with the running sum

Any suggestions fingers crossed
Chris

 

[Steve Schapel]

Chris,

I would recommend that you don't use code to assign the values to the
txtFIN etc textboxes. Either use the Control Source property of the
textbox. Or calculate the values in the query that the report is based
on, in which case these textboxes will be bound to the calculated fields
in the query. Something like this, probably:
FIN: IIf([TransType]="FIN",[Debit],Null)

 

[Chris]

Thanks Steve
That does the trick

Chris,

I would recommend that you don't use code to assign the values to the
txtFIN etc textboxes. Either use the Control Source property of the
textbox. Or calculate the values in the query that the report is based
on, in which case these textboxes will be bound to the calculated fields
in the query. Something like this, probably:
FIN: IIf([TransType]="FIN",[Debit],Null)

--
Steve Schapel, Microsoft Access MVP

Getting very frustrated. Trying to create a report to act as a receipt
for payment received where the payment is applied against a number of
outstanding dues.

Have a query as the basis of the report with fields Debit, Credit,
TransType, TrandDate, ReceiptNo (grouped on receipt no)
One receipt will consist of one payment (Credit) and numberous debits and
depending on the TransType the debit amount is to be shown in different
boxes. ie: Dues, INI, Fines, WDR etc

I have tried putting unbound text boxs (txtFIN, txtDue, txtINI etc) in
the detail section and then running code on the format event that would
check the transtype and then update the corresponding text field. The
totals for these fields would then be summed in the Report Header or
Footer which would print as the actual receipt. where the fields in the
header would have the control source as =Sum(txtFIN) etc

Keeping getting "Enter Paramenter Vaue" prompt on the unbound text fileds
so obviously not doing something right with the running sum

Any suggestions fingers crossed
Chris