Access / Automatically generate a report from a form?

Turnip12 · September 13th, 2002, 12:29 PM

Is there anyway to automatically generate a report from a form? I'm trying to customize an app so whenever you enter a new record into a form, you can click on a button to save the new form and automatically generate a new report based on the info from the recently created form. I already have the layout of the form saved as a template, and I have all the current forms linked to the current reports. I don't, have a table created, is that what I'm missing?

howste · September 13th, 2002, 12:54 PM

If I understand what you're doing, it seems like what you would want is one form and one report. When you enter data into the form, you would have a button open the report and filter the data to display only the record you just entered.

Am I close?

howste · September 13th, 2002, 01:15 PM

Quote:

Originally posted by Turnip12
I don't, have a table created, is that what I'm missing?

I must have missed that part the first time I read this. You would need a table to do what I was talking about. The form would be linked to the table. When you enter the information into the form, it's stored in the table. The button would open the report (also linked to the table) and display the information from the form.

Turnip12 · September 13th, 2002, 01:54 PM

Thanks for the replies, yes that's what I'm trying to do. So in order to do so, just create a table with the fields I want on the report/form and then link the the forms and reports to the table? For the button do I need to use VB to generate the reports, or is there an option somewhere. I stumbled across the autoreport option, but I'm new to Access and I wasn't sure if that's what I'm looking for.

howste · September 13th, 2002, 02:11 PM

Once the table is there and the report is created, you should be able to use the wizard when you create the button. It should pull up a dialog box like the one attached (I'm using Access 2000). You'll then choose the report you want to display. The wizard will create the VBA code that will display the report. You'll probably have to tweak the report after that to get it to display only the record you want.

That should be enough to get you started. If you need more help, post back again. Good luck!

Turnip12 · September 18th, 2002, 02:08 PM

Thanks for your help before, I'm hoping you'll stumble on this again (or anyone else who might be able to help for that matter) When creating the table for the forms and reports to link to, do I need to create a field for ever field on the report, or just for the text boxes? There are several text boxes on the form that I'll need to set up so the values can be changed monthly, but all of the rest; labels, logos, etc, will be constant.

howste · September 18th, 2002, 02:37 PM

It sounds like you've figured it out. You only need to create fields in the table for the ones that will change. The rest will just be labels or pictures stored on the report.

ironforge · October 16th, 2002, 02:19 PM

Is there a way to make a report that draws off multiple tables?

DVNT1 · October 16th, 2002, 02:40 PM

Quote:

Originally posted by ironforge
Is there a way to make a report that draws off multiple tables?

yes, one way is to link the report to a query. Then inside the query add tables or other queries as needed

vass0922 · October 16th, 2002, 04:38 PM

yeah you'll need to JOIN the tables though or it'll get pretty messy.