Generate a report of form's data

[mkphan]

I currently have a form with 1 subform. I would like to generate a report base on the data on this form. Is that possible?

Thanks in advance,

MK

 

[mickeyg]

Yes, you can.

1) put a button on your form that displays the report in "preview". Assuming you want your users the ability to preview a report while they are on that form.

2) create a report with all the fields that you have contained on your form.

3) pass the value that you are using to link your main form to your subform in the report's OnOpen event.

This should get you started in the right direction.

Mickey

 

[Smack]

You can also try the following;
Create a query using the Main table and sub table and build the report from the query or;
Build your report from the form and then insert a subreport created from your subform.
I have used both depending on what I need to see.

 

[mkphan]

Thanks to both of you....;o)

MK