Form based on a Query.. would like to view results in a Form view

[Eana]

Can you please help?

I have a Form A in which the user enters all of the Search Criteria.
When clicking OK on Form A, Query 1 receives these parameters and runs a query against a Table.
Results are obtained and the user sees the results of Query 1 in Datasheet View.

I would like to display the results in a Form View and not Datasheet view. How can I accomplish this?

Thank you

 

[missinglinq]

By "form view" I assume you mean "Single Form View." There may be a better way, but try this:
1) Make a form that uses the query you run as its RecordSource
2) In code, after your query runs, close it
3) In the next line of code, open the new form

Good Luck!