Report from Form

[Freckles]

Cross Posted at Reports

I have a form consisting of 5 memo text boxes. At the bottom of the form, I have a print preview button formatted with the Wizard that points to a report with the 5 memo boxes concatenated. The report is based on a query that refers back to the form with the correct record selected. Now here is the rub.

When I try to preview the report just after entering the text on the form for that particular record, no data appears on the report. But, if I close the form, then open it up again, the report is perfect. : Deb Koplen
deb.koplen@verizon.com

A person can stand almost anything except a succession of ordinary days.

 

[jhall156]

I think you need to save the record first. Perhaps in the onclick of your button you could docmd to a newrec or use some other method to save the record. JHall