mtech1@yadtel.net (Dale Ring) wrote in
news:d578cae0.0311050949.2e19921e@posting.google.c om:
[color=blue]
> Access 2000
>
> I am trying to add "ALL" to a combo that is used to filter a
> query. When "ALL" is selected no records show instead of ALL
> records showing.
>
> I have setup a "dummy" table (tblDum) with 1 field (txtDummy,
> Integer)with 1 record that has a "0" entered.
>
> The field that is being filtered is an Integer type.
>
> Here is the rowsource for the combo:
>
> SELECT tblProviders.ProviderID, tblProviders.ProviderName FROM
> tblProviders UNION Select 0 as AllChoice , "(All)" as Bogus
> From tblDum;
>
> Any and ALL suggestions are truly appreciated![/color]
There is no problem here, this part works fine. It's what you are
doing when the "All" option is selected that needs to be changed,
but you didn't post that part of your design.
What is in the AfterUpdate Event of your combo? That's what we need
to diagnose your problem.
Bob Q
[color=blue]
>
> Thanks
> Dale
>[/color]
