Using Access 2010
I have a form (frmSelectDates_AllItems_Reports) with a combo box (cboFindActionByID), and a command button.
And I have a report with three subreports on it. The main report is not bound to anything. On the subreports is a field called "ActionByID."
There's an embedded macro on the On Click event of the command button.
I would like to select a name in the combo box, click the command button, and have the report open so all three subreports are filtered by the name selected.
As a first step I've tried to filter only the first subreport. I've tried every single variation known to man, and I keep getting ALL the results in this subreport, and not filtered.
I've checked numerous times that I'm referring to the control name of the subreport and not the subreport's name (I ended up just changing the control name to be the same to avoid any conflict).
Here's what I have:
Open Report
Report Name: rptAllItems_ActionBy
View: Print Preview
Filter Name
Where Condition= ="[Reports]![rptAllItems_ActionBy]![rptAllItems_Completed_Summary_ActionBy].[Report]![ActionByID]=[Forms]![frmSelectDates_AllItems_Reports].[Form]![cboFindActionByID]"
Window mode: Normal
I would appreciate any help or guidance as to which YouTube video to watch or which keywords to search on Google. I've spent over 8 hours searching for the solution before finally giving up and posting here.
Varda