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.

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" wrote in message
...
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.

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" wrote in
message
...
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.


.

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)

"Bob" wrote in message
...
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" wrote in
message
...
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.


.