Viewing query results in form view

[Tina]

I'm using a form where the user can enter search criteria, then click on the
command button and view the query results. I'd like the query results to be
viewed in form-view instead of the usual query datasheet view. How do I go
about changing the view to form view?

Thanks in advance!

 

[fredg]

I'm using a form where the user can enter search criteria, then click on the
command button and view the query results. I'd like the query results to be
viewed in form-view instead of the usual query datasheet view. How do I go
about changing the view to form view?

Thanks in advance!

You're already using a form.
Set the Form's Record Source property to the query.
Set the Form's Default View property to display the results.

 

[kingston via AccessMonster.com]

Create a form based on the query and then change the command button so that
it opens the new form instead of the query. Set the new form's properties so
that it opens in form view rather than datasheet view. Also, you might try
using a subform.