VB print to file code

[Costefran]

Can anyone help

I would like to set up and after action event on a form that saves a report with the open record to file and the name of a saved document would reflect the value of a control named order reference number
So if the value in my Order Reference Number is"COFF01"

In laymans terms the action would go something like this

Controlz after udate

If [controlz]="Approved" then save a report called "current record" to (File Path) and call the saved document [Order Reference Number] which = COFF01......02 and so on

Any help would be appreciated as I have no idea where to start with coding

Thanks

 

[Remou]

You could reference the form order number control in the query on which the report is based and then use OutputTo to save the report to disk.