AlexN
Registered User.
- Local time
- Today, 05:49
- Joined
- Nov 10, 2014
- Messages
- 302
I have a totals query that shows results in a chart. It takes a parameter to limit results, by a combobox in a form.
Parameter in the query includes the OR “*” expression, in case someone wants to get the results unfiltered.
The Combobox in the form, has an AfteUpdate event that opens the chart (form) every time its value changes, by the [DoCmd.OpenForm “ChartForm” , acNormal] expression.
Problem is, I don’t know how to make it open the ChartForm when no parameter is selected in the combobox.
Any ideas?
Thank you
Parameter in the query includes the OR “*” expression, in case someone wants to get the results unfiltered.
The Combobox in the form, has an AfteUpdate event that opens the chart (form) every time its value changes, by the [DoCmd.OpenForm “ChartForm” , acNormal] expression.
Problem is, I don’t know how to make it open the ChartForm when no parameter is selected in the combobox.
Any ideas?
Thank you