Report Trigger

[lewando_bria]

I was wondering if it is possible to set some sort of trigger so that everytime a new record is added to the database, a report is made and printed out ... i am new to access and any help would be shaweet

 

[cadillac]

you could try using the afterupdate or onclose event in the form where the new records are added to do this. you can create a temporary table that the form inputs the information into, then when the form updates or closes tell the report to print. after it prints, append the data from the temp table to the main table and delete the contents of the temp table for next time.

it works for me, although it may not be the best way to do it.