class module to recordset

[dpimental]

Are there any quick and dirty ways to transfer data from a recordset to a class and back to a recordset again.

Example:

I have an "orders" recordset.
I have an orders class

I want to be able to pass data back and forth between the class and the recordset.
Is there any easy way to do this?

Also, is it possible to bind a form to an object?

David Pimental
(US, Oh)

 

[PWise]

What are you trying to achieve

 

[dpimental]

The requirement of the project is to have off-line record sources that I either pull from the database or create.

There are several types: inquiries, orders, institutions, etc.

Each gets either pulled from a database or created.
Each is then passed around to various processessing points. The record may need preprocessing, then go to a form to be maintenanced, and then may need post processing before being written out to the database.

I had thought that I could use a class module to put the data into, update it as needed, and eventually write it out to the database.

I have created a class and several methods to convert it to and from a recordset to a class.

comments ...

David Pimental
(US, Oh)

 

[strongm]

Try investigating "disconnected recordsets"

 

[dpimental]

I thought about using them - but since I had used the entity framework in .net, I thought that I would try something like that in vba.

Maybe I should investigate using disconnected recordsets instead.

Thanks for the tip.

David Pimental
(US, Oh)