How to make an access 2010 form that I can pass any table to for display -

How to make an access 2010 form that I can pass any table to for display -

access 2010: able pass recordset @ runtime form displayed datatable. see easy take table , create form show info table need more dynamic. possible in access. when seek passing record set pre-existing form made table shows columns matching name , marks others ????? beingness unable figure out set in there. don't want maintain form attached record set after user done it.

i able kinda adding controls form

docmd.openform "frmdynamite", acdesign ', , , acformreadonly, acwindownormal set frmsub = forms!frmdynamite = 0 frmsub.controls.count - 1 on error resume next deletecontrol strformname, frmsub.controls.item(i).name next on error goto 0 = 1 rspop.fields.count - 1 set ctl = createcontrol("frmdynamite", actextbox, , , rspop.fields.item(i).name, 5, 200, 300, 288) next runcommand accmddatasheetview set application.forms("frmdynamite").recordset = rspop application.forms("frmdynamite").requery

however final users running under access runtime don think work...

access-vba ms-access-2007 ms-access-2010