Cascading Combo Boxes and Select "ALL"

[Red2003XLT]

Okay, I know how limit one combo box to another combo box.

Heres the wrinkle now I'm bing ask to provide a select "ALL" option'.

One table columns are as follows: Business Rules, Date Discussed, Issue
Discussed

combo box 1 Business Rules
combo box 1 Date Discussed

Now my boss wants (Business Rules)"All" by Date discussed.

Any ideas????//

 

[Krzysztof Pozorek [MVP]]

(...)

Now my boss wants (Business Rules)"All" by Date discussed.

Try to write something like this (and modify it to Your needs):
SELECT Date1 FROM Table1
UNION ALL SELECT Max("<All>") FROM Table1
ORDER BY Date1;

KrisP, MVP, Poland
www.access.vis.pl

 

[Douglas J. Steele]

(...)

Try to write something like this (and modify it to Your needs):
SELECT Date1 FROM Table1
UNION ALL SELECT Max("<All>") FROM Table1
ORDER BY Date1;

Be aware, though, that if you're using the combo box as a parameter in a
query, you'll have to change the query so that it handles the "<All>"
selection in the combo box correctly. Assuming your SQL currently contains
something like

WHERE Table1.Field1 = Forms!Form1!Combo1

you'll need to use

WHERE (Table1.Field1 = Forms!Form1!Combo1 OR Forms!Form1!Combo1 = "<All>"