Aug 9 2005, 06:20 AM
Can anybody explain how to pass a value which is in a drop down menu as a parameter to a query which will be the record source for a report...
Aug 9 2005, 07:01 AM
On the criteria row of the query enter the expression Forms!Formname!controlname , substituting your form name and cotrol name. The form must be open when the query runs.
Aug 9 2005, 08:08 AM
Adding to Glenn's post, I usually put a command button on the form that opens the query and/or report.
Aug 9 2005, 02:11 PM
Ya, I have tried that... Attaching a sample dbase...
but here is what I am looking for...
The report displays all the case count for 12 months...and it is for different years...
I need a form that will accept year as input and will open the same report displaying records for only that year...
I hope I am clear.
Aug 10 2005, 12:14 AM
I do not have the report working. However, I did manage to get the crosstab query to work using a date entered from the form. Crosstab queries are different animals from the normal run of the mill select queries.
I have attached my work. Form1 is the form that matters. I also changed the Crosstab query by putting an entry in the Parameters dialog box.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here