Use report textbox in sub-report record source query

[aebstract]

I have a report that has one sub-report within it. I have a textbox in the Detail section of the report that I want to pass in to my sub-report and use within it's "record source" sql query. I've tried several different things but am unsure how to accomplish this. I've searched a good bit and have come up short as well. Trying to use "textbox50" in the WHERE clause.

SELECT dbo_MIBORD.opCode, dbo_MIBORD.milestone
FROM dbo_MIBORD
WHERE (((dbo_MIBORD.milestone)=True) AND ((dbo_MIBORD.bomItem)=[Me]![text50]));

[pbaldy]

You can't use "Me" outside VBA. Try the full reference:

Reports!ReportName.text50

You'll find more descriptive object names very helpful down the line.

[aebstract]

You can't use "Me" outside VBA. Try the full reference:

Reports!ReportName.text50

You'll find more descriptive object names very helpful down the line.

Thanks a lot! This did it perfectly. Normally, I would be more descriptive in things like the textbox name for reference, but this is just a quick small and simple report so I wasn't too worried in this case.

[pbaldy]

Happy to help!