Listbox selection to table

P

PLD

I have a unbound list box that i create the select (SQL) row source. If no
data is found the list box contains a blank that the user can select. Can
this be controlled so only items in the select (SQL) are used for selection?
 
A

Al Campagna

PLD,
Without further information about the table, and the List SQL RowSource...
You should be able to criteria that query for Is Not Null values.
--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."
 
Top