Just struggling with the VBA reference.
My Main form is based around a table with one entry "Quarter"
My sub form is linked to show only the data with the same "Quarter"
I then need to filter my (datasheet) subform by status.
I want a command button that filters the subform by "to be actioned" in the status field.
If the data was on the same form I would use:
DoCmd.ApplyFilter , "status = 'to be actioned'"
How do I reference the subform from the main form?
My Main form is based around a table with one entry "Quarter"
My sub form is linked to show only the data with the same "Quarter"
I then need to filter my (datasheet) subform by status.
I want a command button that filters the subform by "to be actioned" in the status field.
If the data was on the same form I would use:
DoCmd.ApplyFilter , "status = 'to be actioned'"
How do I reference the subform from the main form?