Open Query to Filter by Form

[Guest]

Is it possible to open a query directly into Filter by Form view?

I want to open a query directly into Filter by Form so that the user can
select the right value from the dropdown and see only those records in the
dynaset. (Parameter doesn't work because value in dropdown is a little tricky
for data entry.)

 

[JohnFol]

Queries can't be opened as any sort of form, so your question doesn't make
much sense.

Am I right in saying you have a combo box on an existing form, and based
upon what is selected you want the resto of the form to be filtered?

 

[Guest]

I mean the 'Filter by Form' command which is available on the query toolbar -
it's the coffee filter with the little form behind it. It opens filter view
so that you can select a value from a dropdown and when the filter is
applied, the dynaset shows only that value. I can get it once the query has
run, but I want to open the query directly to that view.

Here's my situation:

I have a combo box on a form which opens as a dialog box. The value selected
in the combo box runs a query to show me which users are assigned which
license (this in turn drives a report). I cannot edit this query because it
involves four tables. I want to create a button on my dialog box that allow
me to edit which user has which license. I have created a simpler query that
will allow me to do this but can't get it to use the criteria from the combo
box because of how the relationships are established. So, I want to have the
Edit button open the simpler select query into the 'Filter by Form' view so
that my db user can pick the appropriate name from the dropdown in the query
and run the filter to see only that person. Then they can change the
assignments accordingly.

There's probably an easier way to do this but I don't know it. Any advice is
appreciated.

--
Thanks,
GillianHG

Queries can't be opened as any sort of form, so your question doesn't make
much sense.

Am I right in saying you have a combo box on an existing form, and based
upon what is selected you want the resto of the form to be filtered?

 

[Guest]

give me the SQL of your query - may be I can help you.
Lana

I mean the 'Filter by Form' command which is available on the query toolbar -
it's the coffee filter with the little form behind it. It opens filter view
so that you can select a value from a dropdown and when the filter is
applied, the dynaset shows only that value. I can get it once the query has
run, but I want to open the query directly to that view.

Here's my situation:

I have a combo box on a form which opens as a dialog box. The value selected
in the combo box runs a query to show me which users are assigned which
license (this in turn drives a report). I cannot edit this query because it
involves four tables. I want to create a button on my dialog box that allow
me to edit which user has which license. I have created a simpler query that
will allow me to do this but can't get it to use the criteria from the combo
box because of how the relationships are established. So, I want to have the
Edit button open the simpler select query into the 'Filter by Form' view so
that my db user can pick the appropriate name from the dropdown in the query
and run the filter to see only that person. Then they can change the
assignments accordingly.

There's probably an easier way to do this but I don't know it. Any advice is
appreciated.

 

[Guest]

Thanks Lana for the offer but I figured out a work around. It's not pretty
but it will do - I made too many changes to accomodate it to undo it, even if
another solution would be simpler.