Can anyone help - I have to use unbound forms in app - for instances of single objects it's trivial I just set the text boxes values on a single form to properties of the class. The single class instance is populated via ADODB recordsets. methods are in place to reconnect to the db after edit / add / delete records and update the table data

I have created a collection class that creates a collection object that holds individual instances of the objects instanced from the first class. Does any one now how to populate an ubound datasheet form with data in the collection object. The datasheet fields are text boxes with data and calculated fields corresponding to properties of the class object

Collection1
Cls1obj1, Cls1obj2, Cls1obj3 etc

form.txt1 = cls1.property1
form.txt2 = cls1.property2

and so on

Regards

Jon