Get Distict records from a recordset multiple time using subquery

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
 
B

bhicks11 via AccessMonster.com

Sure, you are only reading the records in a combobox. What else will you be
doing? You will trip over yourself if you open the records multiple times
and make changes.

Bonnie
http://www.dataplus-svc.com
 
V

vqthomf

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
 
B

bhicks11 via AccessMonster.com

So are you working in Access or Excel? If it is Excel - this is an Access
forum and you would get better help in an Excel forum.

Bonnie
http://www.dataplus-svc.com
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
Sure, you are only reading the records in a combobox. What else will you be
doing? You will trip over yourself if you open the records multiple times
Click to expand...
[quoted text clipped - 8 lines]
Click to expand...
 
Top