parameter combo box queries

[Tank04]

I have a parameter query which uses a combo box. When I pull down a name
from the list it shows the report with that name. Is there away to show all
records of the people in the combo list. On the query the criteria is listed
as [forms]![parameter]![resp] and that works for individual selection. I
have tried adding to the query Like "*" but all I get then is all the records
even if I choose one from the list.

Is there anyway to overcome this please.

Thank you

 

[Guest]

Tank04:
What you could try is to create a second combo box (a copy of the first) and
have the user select a starting and ending value for the report/query. This
would enable you to ran the report/queryfor a single value, all values or for
a range of values. The criteria would look something like....
between [forms]![parameter]![resp] and [forms]![parameter]![resp2]

Where [forms]![parameter]![resp2] is the copy of the first combo box.

Hope it helps,
FatMan