An all in one parameter query possible?
I would like to use a default report to display results of a users search. On a form, a combo box would allow selection from one of several values, dealer#, invoice#, reference#…etc…of course these fields would appear on my report.
After a user selection from the combo box, a goButtonClick ought to ask for a parameter based upon the users selection from the combo box. Once the user enters that info & clicks ok, the report would pop up using the parameter info as the filter.
My problem is how to pass a parameter between the different values in the combo box so that the report displays results based only on that single parameter?
I would like to use a default report to display results of a users search. On a form, a combo box would allow selection from one of several values, dealer#, invoice#, reference#…etc…of course these fields would appear on my report.
After a user selection from the combo box, a goButtonClick ought to ask for a parameter based upon the users selection from the combo box. Once the user enters that info & clicks ok, the report would pop up using the parameter info as the filter.
My problem is how to pass a parameter between the different values in the combo box so that the report displays results based only on that single parameter?
