Board index MS EXCEL

Filiter and Limit selection in Combo box / List Box in the Use

Filiter and Limit selection in Combo box / List Box in the Use

Post by SWN5 » Sun, 04 Nov 2007 03:40:03


Thank you for your reply.
Yes, I do want to dynamically change the selection in the drop down list. So
if I have entire such as
Apple
Ace
Appointment
Bee
Bread
Beach
normally, on the combo box it will show all the selection to the user to
pick, I want user type A all the selection starting with B will be taken off
from the selection list. When user type B all the selection starting with A
will be taken off. so user can scroll up and down the list and choose what
they need in that range. I don't know whether this is possible for combo box
to do, or do you know if there any other way to accomplish this. Thanks again!
 
 
 
Top

1. filtering or limiting combo/list box from another combo/list box

2. Combo Box on Main Form and limits Combo Box selection on the Subfo

I've read several of the Cascading Combo and I'm still a bit confused please
help.

I have 3 tables:

1st table "Controls" - Main table
Location_Id (Auto)
Location (Key)
1stQtr Money
2nd, 3rd, and 4th


2nd Table "Control Number"
ControlNumberIDv(key)
ControlNumber
Location (1 to Many)

3rd Table "Confirmation Table"
Confirmation_Id (Key)
Location (1 to Many)
Date Processed

I have a "Main form" which uses "Controls" as it source and a subform called
"Confirmation Subform" which uses the "confirmation Table" as it's source.
On the Main Form I have a Combo Box for "Location". On the subform I want a
Combo or List box which will display only those records associated with the
location from the main form.


Thank You

3. limiting combo box selection based on another combo boxes selectio

4. limiting combo box selection based on another combo boxes sele

5. Limit list of combo box based on selection of another combo

6. combo box list based on the selection in another combo box

7. Changing combo box list based on another combo box selection

8. How to limit combo box list based on value in another combo box?

9. Combo Box - how do you populate/filter it using another Combo Box Selection

10. using selection in combo box to filter another combo box display

11. using selection from combo box as input to a 2d combo box

12. Using one combo box to narrow the selection in another combo box

13. Using a Combo Box to limit the entries of another combo box

14. limit one list box data set based on selection in another list box

15. Limiting a combo box with another leads to read only state of limited combo box

All times are UTC
Board index