Multiple Criteria DLookUps

[Vidar13]

I'm trying to lookup a value based on more than one criteria in a report. Is there a way to do this with the DLookUp function?

If not, is there a way to pass the current page value of a report back to a parameter query that would filter based on more than one field's criteria?

 

[Vidar13]

One other thing I wanted to clarify:

I've used the [Forms]![FormName]![FieldName] as a parameter in a query and it works fine (so long as the form is loaded), but it doesn't seem to apply to reports. I'm trying to use the [Reports]![ReportName]![FieldName] but it comes back with an empty recordset each time.

 

[Vidar13]

No one has any ideas on this?

 

[JoeMiller]

Reports are only for displaying data, they can't be used to supply data to another place to run another report/query/form like you're trying to do.

What is it you're trying to accomplish and maybe I can help you come up with a better way to do it. Joe Miller
joe.miller@flotech.net

 

[Vidar13]

Okay, that's what I suspected. I was able to find an article on Microsoft's KB that covers multiple criteria DLookups, which I've been able to accomplish the same end goal from within the report itself.