FORM BASED ON A QUERY

[Kevsim]

I have a form based on a query.
There are 5 Combo Boxes (CB ?), 1 Text Box (T1), 6 Tables and 1 Query. The 6 Tables make up the query.
I want to make a selection from CB1, then CB2 only drops relevant data from what was selected in CB 1. Make selection from CB2 and CB3 only drops relevant data from what was selected in CB2. Make selection from CB3, then CB4 only drops relevant data from selection of CB 3, also it is only possible for T1 to have one answer from the combination of the selections of CB1, CB2 and CB3.
When selection is made from CB4, then CB5 only drops relevant data of CB4.
I used SQL and Visual Basic (VB). Data is selected from CB1, and does requery for CB2 (VB), CB2 Selects a Distinct Row (SQL) and does requery for CB3. When I try the same thing for CB3, CB3 has data to select, after selecting, no data appears in CB4. Can this system only work with 3 Combo Boxes and if so, how do I make it work for the 5 Combo Boxes and also place the data in Text Box T1?
I would appreciate your advise.
kevsim

 

[JoeMiller]

Try out this FAQ by RickSpr. It should help you with the limiting of combos on other combos.

How do I limit the contents of one combo box based on the selection in another?
faq702-681

And in answer to your question, 5 is not too many combos. As for deriving the answer to T1, I don't see this being an issue either. I can't tell you how you'd do it because you haven't given any sample data or examples how to derive it, but it is possible.

HTH Joe Miller
joe.miller@flotech.net