Using a report to create an invoice

[jordsta95]

Hey there, well I'm having an issue trying to get a report to show a single customers' data on one report.
The way I am doing it at the minute isn't really a way I would like to do it, using a query to create the report, but I don't know how to do it via a form.
Basically when I do it at the minute, it will create an invoice... but with every customers' data on the same report.

But what I want to do is have it so that when I create a new record in a form, when I press a button it will create a report with just the information in that form and the details of the customer (as the form only uses the customers' ID)

Is there a way to do this? If so, it would be great if you could explain... maybe in a way you would explain to an idiot as I don't understand reports at all :/
Thanks
-Jordan

 

[pbaldy]

Using your existing report you can use this technique:

http://www.baldyweb.com/wherecondition.htm

Make sure the displayed record is saved first.