Hi guys,

I need some advice about binding controls to recordsets...

I'm working on an app that has several forms with controls that show records from two separate recordsets..

I'm trying to write a routine that will bind all of the controls on a form to a recordset .. The idea is that the code loops through all of the controls of the form and if the control has a tag set (which is in the form recordset.fieldname then I can use the two parts of the tag to set the Datasource and Datafield properties of the control.

The problem I've got is that DataSource is an object and the recordsetname from the tag is a string.

Is it possible to turn a string into an Object Reference so I can set the datasource with the text from the tag?

Or....

Do you have any advice about the best way to bind controls to recordsets, or get the info from recordsets into controls? This is always a sticking point for me when I'm writing apps because doing it manually is so tedious..

Any advice gratefully received.

Thanks guys,

pad.

i didn't quite get your post, but to my understanding, you could copy all the record on both form, and create a table at run-time, put it to the table. and when you are through, you could delect the table and all the duplicated record. tell me what you think!

Arowolo