Parameter qry and forms

[Guest]

Hi - I've created a parameter qry based on the input of 2 comb boxes on a
form. You click ok on the form, the form closes and the qry displays. However
as this is for non IT users, I would like the qry results to display back in
the form. Does anyone know how to do this please? When I have tried adding a
subform to my form based on the parameter qry, it just asks me for the
parameters again. Do i need to somehow save the results of the qry and then
re-display them onthe form. Thanks

 

[Allen Browne]

If your form is in Continuous Form view so it displays one record per row,
you can put the combos into the Form Header section. (View menu if you don't
see a Form Header.)

Since you don't need the subform, the query will work.

If you want a more powerful type of search where the user can leave some of
the search boxes blank, there's an example database you can download form
this article:
Search form - Handle many optional criteria
at:
http://allenbrowne.com/ser-62.html

 

[Guest]

Is the parameter qry likley to return more than 1 result?

You could duplicat(replicate) your form and base the form on your query
However its unclear from your explanation how the user might interact with
your form, ie how often would they have to run the query?

If they have to run the query more than once, functionality for that would
have to be built in.

Hope this helps

 

[Guest]

Thanks to both Steve and Allen.

The user will run the search quite a few times. It basically returns a list
of hyperlinks to relevant documents via 2 search criteria. Am I able to post
an example to show you guys? Cheers

 

[Allen Browne]

Try the examples.

We want to help you find your own solution rather than do it for you.