[AccessD] AccessD Digest, Vol 47, Issue 40

And the proper MDAC libraries installed. ;o>

Charlotte Foust

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Ken Ismert
Sent: Wednesday, 24 January 2007 10:54 a.m.
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] AccessD Digest, Vol 47, Issue 40

John,

I should read my own article: this works for Access 2002 and later.

Basically, you open an ADO recordset, then disconnect it (Google "ado
disconnected recordset" for instant code examples).

Then, in your form code, set the combo Recordset property to your
disconnected recordset:

Set Combo.Recordset = rst

Should be a snap for you to integrate something like this into your
framework -- provided the client has Access 2002 or later.

-Ken

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com