Get Distict records from a recordset multiple time using subquery

  • Thread starter Thread starter vqthomf
  • Start date Start date
V

vqthomf

I have to load distinct records into more that one comboBox and was wondering
if it was possible to open the database once by selecting all records and
using subqueries on the same records.
Regards
Charles
 
I am using excel vba to fill the combobox but to do this I have to open the
database more than once and it is slow I was just wondering if it could be
done.
Regards
 

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

Subquery help 7
Subqueries 3
Subquery can only return one record when used inside the WHERE cla 2
Referring to fields in a subquery 1
SQL or maybe a hardware issue for finding lowest Repair order date or mileage 1
Dates Subquery 1
subquery - at most one record can be returned 2
Return Multiple Values via Subquery 3

Back
Top