Combo Box for a list of records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I create a combo box that can be used in a column of data (ie, having
a column of states and a combo box of all the states instead of typing in for
each record)
 
I figured out how to use data validation for this. The next step would be to
filter the list based upon the value in another field (in the same
record/row). IE, if I selected Illinois, the City colum would only list
valid cities in IL? Any suggestions?
 
One way is to create Filter. Select your data including the column
header. Then click on Data Filter. From DropDown boxes on the top
row you can make a selection.

AQIB RIZVI
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I create a combo box that is tied to another combo box? 2
Counting Combo Drop Down Box Selections 1
View List Items in Combo Box 6
Using a combo box for more than one group of cells 1
synchronized Combo Boxes in subforms 2
Linking to combo box selection 2
Combo boxes and AutoSum 1
Cascading combo boxes - are they able to do this? 6

Back
Top