Automatically open Make Table from Query

[jabrjo]

Hello,



I am creating a form that has a number of parameter based button queries. I want to be able to click the button, run the query and open the newly updated make table. Is there a way to get the "make table" to automatically display (without the user going into the table list and selecting the table)?

Thanks!

[June7]

Why are you making new table? Process that regularly creates new tables is poor design.

[jabrjo]

Im not very good with Access and it was the only thing i could think of right away...
I want the user to be able to reference data in the database without actually being able to edit the main table.
Here is what i need if you have a better solution that would be fairly easy to implement (via the design view/expression builder). I want the user to be able to select the city, state, or region via a form, then have all the records associated with the selection (city, state or region) display in a separate table/form/report.

Would a SubFrom be a better option?

Let me know your thoughts and I'm open to any suggestions.

Thanks!

[June7]

I don't know your data structure. You have a 'main' table with some unique records then there is a related table with more data you want to allow users to view? Do you want them to be able to edit these records?

[jabrjo]

If the query opens a subform with all selected records, then yes editing would be great. If the query opens a related table, i just want it to be used as a reference.

[June7]

Query does not open anything. An Access query is an object that can be opened. A form (or report) can be based on a SELECT query. Can open form or report and apply filter criteria.

Options for filtering records:

1. open table or query and apply filter with the intrinsic Access sort/filter tools

2. static criteria manually typed into a query design or dynamic popup parameters in query (I NEVER use query popups)

3. open form or report based on query and pass filter criteria to the form or report object
Review:
http://www.datapigtechnologies.com/f...tomfilter.html
http://allenbrowne.com/ser-62code.html

[jabrjo]

Thanks for taking the time to help!