getting information from multiple variables into a report

[Tom B.]

I have an application in which I get information from a number of different
tables and queries. I wind up with a recordset of about 8rows and 11 columns.
When I view it in the Immediate window, everything looks fine. However, when
I try to write it to a form in which I have one row of textboxes, I cannot
get the form to expand the number of rows shown. The form only displays the
one row with data from the last record in the recordset showing in the
Immediate window. How can I display a varying number of records in the form?

 

[Duane Hookom]

I'm not sure what the immediate window has to do with records displaying on a
form. This is even more confusing since this is the "reports" news group.

If this is actually a form question, take it to the Forms Coding news group.
If it is truly about displaying information on a report, then try to provide
additional information. The typical method of displaying information from
tables in a report, is to set the report's record source property to the
table(s)/query.