Ken Ismert
kismert at gmail.com
Wed Jan 24 12:54:29 CST 2007
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