Show Query Results in a Form View

[Guest]

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.

 

[Rick Brandt]

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.

Create a form and bind it to the query.

If you select your query in the db window and press the AutoForm button it
will quickly create a form bound to your query. All you have to do is
change the layout to what you want.

 

[Guest]

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?

 

[Rick Brandt]

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?

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.

 

[Guest]

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.

 

[Rick Brandt]

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.

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.

 

[Guest]

Thanks for your time and patience. This has helped tremendously.