Drop bown lists
 

I'm trying to create a combo box where the list will vary
based upon a state that is chosen. The state is
determined by a different combo box. 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.

Drop bown lists
 

We've already answered this.

--

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. The state is
determined by a different combo box. 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.

Drop bown lists
 

Why not just answer it again?

Anyway

What might work is if you sort the list everytime you
enter a new record, in order to move the empty cells to
the bottom.

-----Original Message-----
We've already answered this.

--

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. The state is
determined by a different combo box. 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.



.