open a criteria based Report from a form, How to?

[bjayhome]

Hi All,

I want to use a Form to get parameter values (criteria’s) from the user for a Query, and then use these values to open a Report, which has its ‘recordsource’ set to the earlier mentioned query.
Could anyone help me? I want to do it through VB code. Thank you in advance for your help.

Bjay

 

[TrojanRabbit]

You can actually do it in the query by saying =Forms![<formname>]![<fieldname>].

To do it in VB, use DoCmd.OpenReport with the wherecondition argument. Less practical alternatives are to set the report's Filter and FilterOn properties or to retype the RecordSource property.

 

[bjayhome]

Thanks TrojanRabbit!
I was so cought up in doing it through code, just overlooked the simplest way.
It's working fine now, I assigned the criteria in the Query itself.
bj