R
rdw1260
I have a form [View Grievance Reports] with several reports set to run by a
single macro [View Grievance Reports Macros]. The form [View Grievance
Reports] has an unbounded list box that uses a table [Grievance Reports
Table] as the row source type. The report based macro works perfectly. I’m
now trying to adapt this form and macro to open a specific query when I
either click or double click on the query listed on the form. I can get the
Query based macro to work if I enter each query for click and double click.
If a query is listed on the form and it is not entered in the macro the query
listed on the form will not open.
I know what is the difference between the actions [OpenQuery] and
[OpenReport]. The [OpenReport] action allows the Action Argument: Report
Name: =[Forms]![View Grievance Reports]![lstReports]. The [OpenQuery] allows
a single named query to open. Is there a way to adapt the report based macro
to work so that I can select a single query from the list of queries on a
form to open?
Thanks for any help.
single macro [View Grievance Reports Macros]. The form [View Grievance
Reports] has an unbounded list box that uses a table [Grievance Reports
Table] as the row source type. The report based macro works perfectly. I’m
now trying to adapt this form and macro to open a specific query when I
either click or double click on the query listed on the form. I can get the
Query based macro to work if I enter each query for click and double click.
If a query is listed on the form and it is not entered in the macro the query
listed on the form will not open.
I know what is the difference between the actions [OpenQuery] and
[OpenReport]. The [OpenReport] action allows the Action Argument: Report
Name: =[Forms]![View Grievance Reports]![lstReports]. The [OpenQuery] allows
a single named query to open. Is there a way to adapt the report based macro
to work so that I can select a single query from the list of queries on a
form to open?
Thanks for any help.