Refer to a report field value in VBA

[templeowls]

Basically, I'm trying to have VBA create a Windows folder named off the value of a report's field. I'm not certain how to reference a report's field value in VBA though. Any suggestions?

[Gicu]

Don't (you can't if the report is not open anyway), use instead the control source of the report's control in a dLookup:
MyFolder=Dlookup("ControlSource","ReportRecordSour ceQuery")

Cheers,

[Micron]

I'm not certain how to reference a report's field value in VBA though.

Same method as you would do for a form.
If your field is a repeating field in the report, you're going to need to add criteria to that. Took me a moment to figure out what happened to the suggestion, so here it is without the extra space:

MyFolder=Dlookup("ControlSource","ReportRecordSourceQuery")

[Gicu]

Thanks Micron, that's way we should always use the code tags.... guilty as charged

[Micron]

TBH I often forego them for a couple of short lines, but I've long been aware of the 50(ish) character break so I watch out for that.