Different way to view query results?

[uncletreetrunk]

Hi all,

I have a search form to run a query to produce matching records from a few tables. However there are many fields so I was wondering if I could make something like a split form to view the results from the query in one window.

I know you can make queries produce tables and you can have split forms linked to table information. I wasn't sure if you could/ how you would run a query and produce a table with a split form.



Thanks in advanced!

[uncletreetrunk]

In short, what's the best way to display query results in one screen with minimum scrolling?

[uncletreetrunk]

Ooop never mind I figured it out!

[uncletreetrunk]

I noticed this was still getting hits and I didn't post any solution. I don't know if this is the best way to do it but it works. So I have a button that 1) Runs a query 2)Opens a split form with a record source of the query 3)Closes the query

This way the user can view the results of a query in an easier to read format.