FORM DIRECTLY TO REPORT.

  • Thread starter Thread starter Joey
  • Start date Start date
J

Joey

Is there a way I can input information in a form and have it automaticallly
go into a report to print? I don't need to save the information on the form,
so I dont want to enter it then run a query..etc..etc...just use it as a
template to do monthly reports on reps.
 
Is there a way I can input information in a form and have it automaticallly
go into a report to print? I don't need to save the information on the form,
so I dont want to enter it then run a query..etc..etc...just use it as a
template to do monthly reports on reps.
Click to expand...

You mean, I'm sure, unbound controls on a form.
Sure.

Create a Report with the same number of controls as there are on the
form.
Set the control source of each control to:
=Forms!FormName!ControlName

Change FormName and ControlName for whatever the actual name of the
form and each control is.

Open the form and enter the data wanted in each control.
Open the report.
As long as the form is open, the report will display the form's data.

Print the report.
Close the Report.
Close the form.
 
If you don't want to store it then why not just type it out in a word
processor. Seems like a lot of work for no reason.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Access Report Works on One Machine but not Another 3
Form with Custom report 2
Form field lookups to next record-compex 0
Report on a form 5
reporting even though a calculation made is dividing by zero 14
Checkbox visible on Report only when checked 6
Button on form to print report for current record 4
Using a form as a base for a report 4

Back
Top