Display Query Form as a Result

[rescobar]

A created a Form called "Search Result" that is populated by my Queries "mainquery"



I have a form called "Search" which runs the query.

When executed "mainquery" opens. I want to hide that from users and have form "Search Result" display. In this form I have set Property Sheet Data to Locked. This way users get a nice looking form and can't edit the result.

[ssanfu]

I have a form called "Search" which runs the query.

How does the form called "Search" run the query???


The form "SearchResult" should have the records source set to "mainquery".

On the form "Search", have a button open the form "SearchResult", instead of executing the query.

[rescobar]

My VB for "Search" form was opening mainquery, I commented that out and changed it to form "Search Result" and that fixed it.