I created different dynamic queries (QD1, QD2...) to give to the users the opportunity to choose how to filter the results.
The problem is that I need to show the results in a dialog box in the form, not using the command DoCmd.OpenQuery "Dynamic_Query"
I don't know how to set the properties of dialog box: i've tried with dialogbox.controlsource=QD1 or dialogbox.rowsource=QD1, but it doesn't work.
What's the right code to do this?
The problem is that I need to show the results in a dialog box in the form, not using the command DoCmd.OpenQuery "Dynamic_Query"
I don't know how to set the properties of dialog box: i've tried with dialogbox.controlsource=QD1 or dialogbox.rowsource=QD1, but it doesn't work.
What's the right code to do this?
