Drop bown lists

B

Bob

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.
 
B

Bob Phillips

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)
 
G

Guest

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.
 
Top