hi
im not quite sure where to post this one, so i thought i'd start here.
so i have a form that have a number of sub forms in it, the form is not bound to a query, so the sub forms are not linked by parent, child. The data is appended to a table, through an append query, which works fine, on this form there is an email button, to email a report with the data from the form, when I open the report and view it, all the data is present, but when i send it via email in PDF format, there is no data, the control source is present, but the data inside is empty, i have checked the sub forms, and there is data in the sub forms, plus i have also tried to apply another sub form, which has data into that particular sub form, and sent it via email from the same button, which i can view and the data is present in the report PDF.
this is totally baffling me, so does anyone have any suggestions as to what could be possibly causing this, or where i should start looking?
im not quite sure where to post this one, so i thought i'd start here.
so i have a form that have a number of sub forms in it, the form is not bound to a query, so the sub forms are not linked by parent, child. The data is appended to a table, through an append query, which works fine, on this form there is an email button, to email a report with the data from the form, when I open the report and view it, all the data is present, but when i send it via email in PDF format, there is no data, the control source is present, but the data inside is empty, i have checked the sub forms, and there is data in the sub forms, plus i have also tried to apply another sub form, which has data into that particular sub form, and sent it via email from the same button, which i can view and the data is present in the report PDF.
this is totally baffling me, so does anyone have any suggestions as to what could be possibly causing this, or where i should start looking?