Displaying all rows of query results on a Form

[pnmng49]

Hi Everyone,

How can I display the full set of a query's results on a form. Example: My query returns n records: OrgID, First, Last, Address, City, State, Zip

I would like to be able to display the results in text boxes on a form. Of course, n can vary with each instance of the query. Currently the query results are only viewable by scrolling through the records because they are all contained in one set of text boxes. I need to be able to view (print) all rows neatly formatted. Also, before printing this form I need to paste some text and sometimes the number n of rows could extend the form onto the next page and sometimes not. Will this create a problem? Should I be working on a Report rather than Form?

 

[georgedwilkinson]

If you want to print, use a report.

To get all the fields on a form or report, use the form or report wizard, select your query from the list, and select all the fields. When done, move the fields around where you want them.

You should be careful, I believe first and last may be reserved words...you should consider re-naming them.