Creating Report from Form

[Guest]

I have form based on a query.
The form lists unpresented cheques and a financial balance. The user then
enters figures relating to amounts not yet paid into the bank account and the
current balance on the bank account. The objective is to reconcile the bank
balance.

Example....

List of Cheques

xxx 100
yyy 200

Total 300

Bank Balance (input by user) 1000

Plus amounts not yet credited (input by user) 100

Less unpresented cheques (calculated on form) 300

Balance from ledger (retrieved from query) 800

Difference (calculated on form) 0

I want to be able to produce a report that shows the list of cheques and the
figures on the form.

The report will be printed via a command button on the form.

How do I show figures on the report that were entered by the user on the
form?

 

[Guest]

hi,

let me suggest a simple approach: store those values in a table (which will
have only one record, updated each time you enter new values). maybe there is
a way to do it programaticaly (vba), but this way makes sense, at least for
me.

cheers