Basing form recordsource on a class module

[Charlie Genge]

Hi,

I'm afraid this is a bit of a wishy washy question:
I have lots of data stored in various XML files for which I have written
code (SAX) to interrogate the data and store it in class modules (as
scripting.dictionaries). I takes a bit too long to write all of this data
into a table so I was wondering whether it would be possible to have the
recordsource (or the datasource of controls on the form) to be the data
stored in the dictionaries in the class module?

Thanks very much and I hope that is relatively clear!!

Charlie

 

[Stefan Hoffmann]

hi Charlie,

I have lots of data stored in various XML files for which I have written
code (SAX) to interrogate the data and store it in class modules (as
scripting.dictionaries). I takes a bit too long to write all of this data
into a table so I was wondering whether it would be possible to have the
recordsource (or the datasource of controls on the form) to be the data
stored in the dictionaries in the class module?

I'm sure there is not interface like IRecordset. So no, you can't.

Maybe it is sufficent to fill a ListBox/ComboBox:

http://www.fontstuff.com/VBA/vbatut10pfv.htm


mfG
--> stefan <--