Full Version: Open Report In Accordance With Combo
UtterAccess Discussion Forums > Microsoft® Access > Access Reports
bob12
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.
darnellk
Is CompanyID still in your Main Report?
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.