Hi
The simple solution is of course to base a form on the table/query…
It may nevertheless be directly open table/query as in the OpenTableQuery.odb attached.
I only use a single procedure for both: I test the name of the button to choose between the table and the query.
note: my source was here.
As Drew said not sure this is THE final answer - but it works
[EDIT]
If you want to open a query in design view to give parameters, my suggest is to use a form for parameters input, then update the query as in this FR.MACROS_Base_003_RapportParam.odb
Regards