Open Table from query

[memaxt]

Hi there,

I have a query that lists all tables within my access database.

what i want it to be able to click the table name from the query list.

for example my query list is:

Rawdata
Outcomes
Reporter
Tracker

how would I click on Tracker and open in up the tracker table??

is it something like

stdocname = "tablename"
docmd.opentable, stdocname, opentable, acnormal , ," [tablename] = " & me.tablename?????


Many thanks
Max

 

[plog]

You can't do this from a query or a table, you must build a form. Once you do, this is how the opentable method works: (http://msdn.microsoft.com/en-us/library/office/ff194975(v=office.15).aspx)

 

[memaxt]

hmmm..i've created a subform on my main form that contains the query.

how would i apply that code?

 

[plog]

Put a button next to the record on the subform, then use the wizard.