Code help In Access to Auto Print each new record

[jamet1234]

Hello

I am new to VB and need some help with a code. I need to Print a report everytime a new record is added to one of my tables from a form. I want that one record to print. I went to the Access forum and they told me you guys could help me better.

Thanks
Anthony

[OBP]

Anthony, this can be achieved in 2 different ways, the first is to open the Report using the "filter method".
I personally prefer the second uses a query to filter the record and supply the report with it's data.
You can place the VBA in the Form's "After Update" event procedure.

[jamet1234]

Thanks OBP. Can you show me a sample code for the one that uses a query.

Thanks
Anthony