Forms Data Controls :: Use DropDownList To Query Db To Include All Values With Exceptions

Trying to use a dropdownlist to query a database so that it will return all values except 1 (or more in future versions).

For example, assume you had a simple table name "MYFRIENDS" which has two fields named "GROUP" and "NAME" with the following records:

Group
Name
A
John
B
Jane
C
Tony
D
Sue

What I want to do is create a DropDownList that has only 2 list items related to the "GROUP" field. The first list item should return records from the database related to Group A only. Then, the second list item should return all other records EXCLUDING those belonging to Group A.

The drop down list should look something like this (I've put a question mark where I don't know what to do):

[Code]....

After the selection is chosen in the above drop down list, it should query the database and return the desired result. I'm using an AccessDataSource with select parameters. Here's a sample of what that looks like:

[Code]....

Things I've tried that didn't work:

I tried using "Not A" as the the 2nd list item's value. I was thinking p1 would be replaced with the value "Not A" and the query would read "WHERE GROUP LIKE Not A". But, the query syntax "Like Not" is technically wrong. I tried changing the Where Clause to "WHERE GROUP p1" and then replaced the list item's value to "LIKE A" and the second to "NOT LIKE A". Again, I was thinking p1 would be replaced to read "WHERE GROUP LIKE A" and "WHERE GROUP NOT LIKE A". I also tried changing the "SelectCommand" itself so that after the dropdownlist changed, it would first change the selectcommand first and then run the query.

Why the first 2 items didn't work became somewhat obvious to me after thinking about it for a little while. However, I would think the 3rd one would/should work... as long as you have the sequence of events correct which up to this point I haven't been able to figure out.