Listbox selection to table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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."
 
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

Access Cannot select items in listbox 1
Using VBA to select Items in multiselect Listbox 1
Listbox Help (remove selected item) 1
how to determine if the rows selected in a simple multi-selectlistbox have been changed? 2
What are the steps to fix damaged MDF files in SQL Server? 0
Listbox SQL 3
Select record in a listbox 8
Access 2003, how do I know if a listbox has no row selected? 2

Back
Top