Problem with Code

[jackiea]

I am trying to use the following code on the Click Event to filter one subform from another. It is working except for the fact that a parameter box pops up with the Report ID that I clicked on. If I type in the Record ID, then the filter works. I do not want to have this parameter box pop up. Please let me know what needs to be changed for this not to happen. Note that my field Report ID has a space. I am wondering if this is the reason. Thanks in advance.



Private Sub REPORT_ID_Click()
Forms![Top Defects]![tbl_Inspection_Results subform1].Form.Filter = "[REPORT ID] = " & Me.[REPORT ID]
Forms![Top Defects]![tbl_Inspection_Results subform1].Form.FilterOn = True
End Sub

[June7]

As long as names with spaces, special characters, punctuation (underscore is exception) or are reserved words are enclosed with [], should work. Which is why is a good idea not to use those features in names - have to remember the []s.

Never tried to control filter of a subform from another subform.

What works for me is to refer to the container control. I always give the container a name different from the object it holds. Example: Forms![Top Defects].ctrNameHere.Form.Filter =

A subform container SourceObject can be a table, query, form, report. All of my subform containers have a form or report as SourceObject. You reference a table name but is the SourceObject actually a form?