From form straight to report

[JaredNJames]

hi, i have a simple invoicing form which the user enters data into.

i would like it so when the user presses the 'Accept' button, a report is printed in the form of an invoice.

the problem i have is that the information on the form isnt in the table until the form closes (as you already know). So i cant just run a basic query to bring the details through to a report.

Any ideas welcomed.

Jared James

 

[Rich]

Save the record first i.e. RunCommand acCmd SaveRecord

 

[JaredNJames]

nice one.

thanks