NotInList

[rollvoer99 via AccessMonster.com]

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.

 

[Roger Carlson]

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/wa.exe?SUBED1=ACCESS-L

 

[rollvoer99 via AccessMonster.com]

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];