Cascading Combo Boxes and Select "ALL"

  • Thread starter Thread starter Red2003XLT
  • Start date Start date
R

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????//
 
(...)
Now my boss wants (Business Rules)"All" by Date discussed.
Click to expand...

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
 
Krzysztof Pozorek said:
(...)

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;
Click to expand...

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>"
 
Back
Top