Working with Listboxes

  • Thread starter Thread starter Robert
  • Start date Start date
R

Robert

Hi, thanks for any help you can provide. I have a
database that imports a file. The data from the file is
checked agains a table. Any values not found in the
table will display in a listbox. The listbox is based on
query that was created under the query tab. Now I would
like to evaluate what is in the listbox so that I can
create a message. My knowledge of working directly with
SQL is very limmited. Any suggestions? Thanks again.
 
Looks like it is time to learn to work with SQL & VBA.

You can look at the SQL generated by the QBE wizard.
Then in the forms module you can create a recordset (DAO
or ADO) and enumerate and evaluate the records returned.
 

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
Listbox query 3
Evaluate ListBox Value 8
Filter a Listbox 27
Search Listbox vs Table Query 1
Updating a query criteria from a listbox 2
ListBox help 1
Deselecting items in a listbox 2

Back
Top