Controling the list in a combo box

[Bob]

I'm trying to create a combo box where the list will vary
based upon a state that is chosen. Currently, I have a
column setup as my list that will show a blank line for an
invalid selection. However, this means I have 100+ blanks
lines in my dropdown list. I want to get rid of the blank
lines and have tried checking the ignore blanks box in the
validation screen. Ay help would be appreciated.

 

[Bob Phillips]

What triggers the state selection? Is it another combobox?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Bob]

Yes. It is another combobox.

-----Original Message-----
What triggers the state selection? Is it another combobox?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)




.

 

[Bob Phillips]

I have a workbook sample if you want it. Mail me your email address.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)