Drop bown lists

  • Thread starter Thread starter Bob
  • Start date Start date
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.
 
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)
 
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.
 
You must log in or register to reply here.

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

Controling the list in a combo box 3
Drop Down List Format 2
Data Validation List (conditional) 2
Better error message when a user enters a value in a form comboboxthat is not valid 1
Combo Box Data Validation - First Entry Blank 2
combo box - last value 2
combobox value blank 9
Pick from drop-down list gives empty or erroneous result 6

Back
Top