Having multiple records show on a single form

[Access_Newbie_2]

I have a QBF that builds a dynamic SQL statement to filter records in the search....Now on the "Results" page I want to be able to see multiple records on the same page (by default each record is on its own form. I only need 1 line for each record on the original results page then next to each one there is a view button that opens a new form with "Detailed" information... But when i add the same field more than one time on my form it just shows that records info twice..How do i specify that I want the 2nd, 3rd, 4th, etc field to come from the next record so when the user searches they dont have to browse through all the records the search provided to locate the one they want??

 

[Rich]

Use a Datasheet, listbox or continuous form to display the results

 

[Access_Newbie_2]

Ahh thank you!

Continuous form is what Im looking for... Couldnt think of the correct term to pull it up in help. Thanks!