Show Query Results in a Form View

J

john mcmichael

I have a query whose criteria are provided through a form. The query runs
successfully. however, I would like to clean up the results and show them to
DB users in a form as well. Unfortuately, I have not been able to figure
this out on my own.

Thanks in advance for the help. I appreciate your support and assistance.
 
J

john mcmichael

Hello Rick,
Thanks for the starting point! One final piece to the puzzle should get me
going. Is there a way then to get the query results to appear in the new
bound form, instead of datasheet view?
 
R

Rick Brandt

john said:
Hello Rick,
Thanks for the starting point! One final piece to the puzzle should
get me going. Is there a way then to get the query results to appear
in the new bound form, instead of datasheet view?
Click to expand...

Just don't set the form's default view to datasheet view. Are you opening
the form or the query? You need to open the form.
 
J

john mcmichael

My appologies. The problem is in my description. I would like to enter the
query criteria in a search form, then click a search button on the form that
runs the query and finally have the results of the query show in another form
instead of in a datasheet.

If I simply use the bound form, as you suggest, I have to manually enter the
criteria in the perameters input popups and I'm trying to aviod that if
possible.

Thanks again. I look forward to your reply. The next beer is on me. :)
 
R

Rick Brandt

john said:
My appologies. The problem is in my description. I would like to
enter the query criteria in a search form, then click a search button
on the form that runs the query and finally have the results of the
query show in another form instead of in a datasheet.

If I simply use the bound form, as you suggest, I have to manually
enter the criteria in the perameters input popups and I'm trying to
aviod that if possible.
Click to expand...

No you don't. If you leave your query exaclty as it is (pulling criteria
from form1) and then have the button on form1 open form2 (bound to your
query) then form2 should show the result of your query.
 
Top