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