Open report in accordance with combo

[fabiobarreto10]

Friends, I am trying to create a report with many fields and tables of different (but related).


As I have many fields, had to do subreports so that the fields to print perfectly.
I have a button on a form, and I'm trying to open the report in accordance with each company that is
selected in a combo.
Before I had a report that I opened with this line of code:

DoCmd.OpenReport "steps", acViewPreview, , "[CompanyID]='" & Me.combCompany.[Column](0) & "'"
But now, as I have subreports this code does not work.
Does anyone have any tips?
Thank you.

[June7]

Why doesn't it work - error message, wrong results, nothing happens? The subreport records don't synchronize? Are subreport container control Master/Child links properties set?

CompanyID is a text field type?

[fabiobarreto10]

Thank you.

Sorry, CompanyID is an integer. Fix the line of code and it worked.

Thank you.