Transfering Data from a form into a report.

[fatmcgav]

Hi,

I have a diff prob this time. In the attached database, the main form contains a generated list of itenary according to the dimensions input at the top of the form. What i cant work out is how to transfer that list into a invoice report that can be printed. The problem is that the list is formatted according to a product, so if i link the form straight into the report, it only displays the prod ref#.
Also, the 'Add New'/'Save' command is meant to add all the pond product quantities to the PondOrderDetail table, but it dosent. How can I sort this?

Thanks for any help.
Gavin

 

[fatmcgav]

Anybody got any ideas?

Thanks Again

 

[RichB]

I have done this before by opening a new unbound report. I put unbound fields and made them =[Forms]![formname]![fieldname]. Not sure if this is the best way but it gives you a snapshot of your form

 

[fatmcgav]

Hi, thanks for the reply.

I have tried it like that already, but the prob is that because the sfrmPondOrderDetail form is a continious form, it only selects the top record, and i need all of the records.

Anybody got any ideas?

Thanks
Gavin

 

[fatmcgav]

Any ideas ppl????