Form Data going to a Report

[Nanette]

I'm sure this is an easy question, but I'm a beginner and just learning about
this process.

I have a form that the user fills in. Once the form is filled in, the user
will be able to click on a button to preview the report and/or print the
report.

I've read about putting unbound text fields on a report and putting the
following in the report text box: =Forms!MyForm.TextBox. I tried this and it
works fine.

My first question is, is this the best way to get the data from the form
onto the report?

My second question is: the form also has a subform on it that displays only
certain rows of data chosen by the user (there might be one row of data or
several rows of data). Can I use the same approach of using an unbound text
box on the report to display the subform data? Perhaps expanding it to
=Form!MyMainform.MySubForm.textbox. Or should this be a subreport. Or is
there a better way to get the data on the form into a report?

 

[Duane Hookom]

99% of data displayed on reports comes from tables. Referencing a control on
a form is rarely used. I would store the values in a table and then use the
table as part of the record source for the report.

 

[Nanette]

Thanks Duane,

I'll do just that and see how it goes.