search Report, Text

[June7]

Never tried to filter reports after they have been rendered. Don't know how charts will behave. If you want to provide, I will check it out.

[mike02]

say you have the same example as i provided before, but instead of having the report open in a Navigationform it has a button beside the combo box, saying [open Table]. I want the report to filter to the name that corresponds to the combo box. now i know You wont be using me.navigationsubform. I was thinking it would be.....
[Report Name].ReportFilter=False
[Report Name].ReportFilter="Fund Name="&me.[Cbo name]
[Report Name].ReportFilter=True

But it doesnt work.


I will attach the example with the charts, i just have to build a template. thanks,

[June7]

Why use the name and not the fund ID? I can't view your project now. Isn't the combobox bound to the ID field? If you want the name must reference the column that has the name. Column index begins with zero. Wasn't name in the first column? - so index is zero.

Me.cboName.Column(0)

I have never used Filter and FilterOn with reports (until your thread). I open reports using WHERE clause of OpenReport.

DoCmd.OpenReport "report name", , , "ID=" & Me.cboName

[mike02]

that doesnt seem to work, it instantly goes into error saying Invalid use of Property, the Column(0). so i removed that and i got this error: Doe not recognice ID... and before that it says it is print it. now i assume it goes into print because i have a print button on the form.

[June7]

I will wait for your next db version.

[mike02]

its not letting me upload a file, the upload just expires. I added the view in your code as acviewreport and that would bring up the report, however it says it doesnt recognize id?:S

[mike02]

thanks for your help! i got it to work!! everything i needed thanks!!