Unanswered: Multiple variable passing from form to report datasource.
Hullo gentlemen, hopefully you guys may be able to help me out here..
After two days of research I'm still stumped, so here goes.
I've been requested to redesign our access adp interface to allow full parameterization of the reports. Basically I need to pass parameters from a text box to the datasource of the report. Where I run into problems, is when I attempt to pass large strings to a variable.
Here is a sample sql source:
SELECT company.company, company.comp_address, company.comp_city, company.comp_state, company.comp_zip
The issue comes into play when passing the where clause to the variable.
I have a form that constructs this variable string from a series of combo boxes named parm1..6. Before opening the report, I assigned an OnClick event that dumps these parameters into a single string, like so: