Use an input form to generate a report

[RussellDeano]

Good evening all,

Again apologies i am a basic access user and still learning the ropes.

I have an input form for my database (which holds details of incidents that occurred at my workplace). The users have always inputted the incident details into the form and then simply clicked "Save" and it gets saved to my database.

For reports the database has always been searched using a query which then displays the reports (incidents between x dates for example).

Now we have to create a report for each incident that occurs. I was wondering if it is possible to automatically generate a report of that individual incident as soon as the user clicks "Save". They can then save the report to PDF and email it to the responsible manager.

I hope this makes sense.

I have not used code in my database and i use macro builder for most things.

 

[arnelgp]

For individual report you can create another unbound report. Each field recordsource is the form object, ie:

=[Forms]! [yourForm]! [Incident ID]

 

[Pat Hartman]

There is no need to create an unbound report.

The RecordSource of the report simply needs to reference the ID of the record displayed on the form:

Where MyPK = Forms!yourform!MyPK

So you can save the report as a PDF and then email the PDF.

If you ALWAYS want to do this, you can put the code into the AfterUpdate event of the form.