Creating a virtual form

hi all,

I need to recreate the forms used by access to control the display of query info.

I have an SP in SQL that kicks out a table of info.

All I want to do is have a generic piece of code that will handle any table structure tha I throw at it. .. Just like viewing a query.

So far I have

Dim frm as new form
frm.recordset = rs 'my recordset
frm.defaultview = "Datasheet"

Now I need to handle the creation of the text boxes

I was looking at appliacation.createobject ... but this can only be used in design view.

Any body any ideas.

I've created multiple controls on form before in design view about 3 years ago and I cannot rememebr how.


any help greatly appreciated.


Thanks in advance Russ