form passing parameter to the report 1

[pthakar]

Hello all,
Is there a way I can pass parameter through a form to a report. I have report rptbldg for all buildings and multiple lease details. I need user to select a submarket and a class from a form fmpass. On Fmpass I have combo box for submarket and class. By click the submit button user would be able to pass the criteria.
Does Any body knows How to do ????
Thanks

 

[WildHare]

Your report should get its' data from a query. The QUERY will get its' criteria from the form's text boxes. As long as the form is open when you call the report, the report will call the query, which will see the criteria on the text boxes.

The criteria cell(s) on the query grid will look something like this, with appropriate substitution for your object names:

=Forms!{Your Form Name}!{Your Field or Text box Name}

For Example,

=Forms!FMPASS!SubMarket








Me? Ambivalent? Well, yes and no....
Another free Access forum:

http://www.forumco.com/jmhare

More Access stuff at

http://www.jmhare.com/wildhare2.htm

 

[ajdesalvo]

You could also open the report and specify a WHERE clause:

DoCmd.OpenReport "YourReport", , , "[SubMarket] = '" & Forms!FMPASS!SubMarket & "' "

Anthony J. DeSalvo
President - ScottTech Software
"Integrating Technology with Business"

 

[pthakar]

Anthony J. DeSalvo
Thank you very much. It works