I have a form called FindLocationsF. On this form are six (6) combo boxes titled PLATFORM, TIMEZONE,DIVISION, SERVERTYPE, STATE, COUNTRY. Each of these combo boxes gets it's list using a SELECT DISTINCT statemnt from a query called DropDownListQ.
I want to make the 6 combo boxes interactive. If I select Eastern Standard Time I only want the other boxes to display material that is available in Eastern Standard Time. If I then select the state of New York I want all the remaining combo boxes to reflect material that is in EST and in New York. I want to use the combo boxes in any order.