Forms or Reports??? 2

[dzdncnfsd]

How do you know when you should use a form instead of a report? I have created several reports based on a query, but now it looks like I should be using forms instead because there are more options for adding code to a form, is this true? If so, is there any easy way to convert my reports to forms or do I have to start from scratch? My problem is, I am creating a payment history and want to show the loan balance after each payment is posted, so I have to have a bit of complicated code that takes the initial balance and either adds or subtracts the next transaction's amounts to get the balance after that transaction and so on .... The only thing a user has to enter is the loan number. The user must have the option to either print, or save the report/form to a file. I am new at VB/VBA, so any help would be appreciated.
Thanks,
Gladys

Gladys Clemmer
gladys.clemmer@fifsg.com

 

[DougP]

A form is where you do work to your database
Add new items, change information etc
A report is what you want to share with others

See my FAQ:
4 main components of Access =Table, Query, Form, Report
faq181-79 DougP, MCP

Visit my WEB site

http://www.barcodeone.com

to see how Bar-codes can help you be more productive

 

[SteveR77]

FYI-

You can go into the design of a form and save it as a report, but this does not work in reverse, due to the purpose of a report vs a form.

 

[ErikZ]

I had just had to convert a bunch of reports into forms. I don't know if this will work for you, but it's how I did it.

Create a blank form, with the same source as your report. Open the report in design view, go to Edit, Select all, Copy.

Go back to your blank form and go to Edit, paste.

Sometimes the alignment is off, but that's easy to fix, just move everything to where you want it.

Later,
ErikZ