Creating a virtual form

[Russ]

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 for
frm.recordset = rs 'my recordse
frm.defaultview = "Datasheet

Now I need to handle the creation of the text boxe

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