NotInList

I am not sure if this is even possible but I will ask. I have a form that
has 2 combo boxes in it. The first selects a department from a Value List.
The second combo box will offer a selection of processes from a list that is
filtered by the first combo box. I am using this to filter a query for a
report becasue after you select the process an option box with 3 choices
filters open, closed or all records.

My question is that with the second combo box I would like to have an All
Processes without adding it to the table. I currently use
SELECT Proces.Process, Proces.ProcessID FROM Proces ORDER BY [Process];
as my rowsource with 2 bound columns. I want to add the All Processes to the
list so the option of showing all the processes in the end report for a
particular department.

Any guidance woud be helpful.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200804/1

Try something like this:

SELECT Proces.Process, Proces.ProcessID FROM Proces
UNION
SELECT "-All Processes-", "*" FROM Process
ORDER BY [Process];

Then you can use the LIKE comparison in your filtering query.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/...UBED1=ACCESS-L


"rollvoer99 via AccessMonster.com" u40720@uwe wrote in message
news:8254f7e532464@uwe...
I am not sure if this is even possible but I will ask. I have a form that
has 2 combo boxes in it. The first selects a department from a Value
List.
The second combo box will offer a selection of processes from a list that
is
filtered by the first combo box. I am using this to filter a query for a
report becasue after you select the process an option box with 3 choices
filters open, closed or all records.

My question is that with the second combo box I would like to have an All
Processes without adding it to the table. I currently use
SELECT Proces.Process, Proces.ProcessID FROM Proces ORDER BY [Process];
as my rowsource with 2 bound columns. I want to add the All Processes to
the
list so the option of showing all the processes in the end report for a
particular department.

Any guidance woud be helpful.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200804/1

Works, thats exactly what I was looking for the UNION is what I was missing.

Thanks


SELECT Proces.Process, Proces.ProcessID FROM Proces
UNION
SELECT "-All Processes-", "*" FROM Process
ORDER BY [Process];

--
Message posted via http://www.accessmonster.com