Shown a table in a form

[jack1080]

I have a table called table1,table2
And I have a form called form1
And I have a dropdownlist that populate all the tables

Now what I want to do is, when the user select the table name of dropdownlist, the table should shown in the form just below the drop down list.
How the table shown is exactly look like when we directly open the table. User are able to see the column name, update the table field, add new table field, etc. The only different is, the table is contained within the form. So, what control should I use? How to bind the table and the control dynamically?

 

[dhookom]

You can use a subform control and set its Source Object to the selected table. There is a sample of setting a Source Object to a query at

http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='DynamSubFrm.mdb'.

You should be able to change the "query" to "table".

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[jkl0]

And also change the form view (of the subform) to "Datasheet".