var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: How to apply filter to subform from button on main form
I have a button on a main form that is supposed to apply a filter to the record source of a subform. I've tried
dim frm as Form
set frm = Forms![subname]
docmd.applyfilter "", "FIELD='value'"
But I keep getting the error that Access can't find the subform, even though it's spelled correctly and does exist.
Anyone have a response on this one?
How about this in the main form button click
Me.SubFormControl.Form.Filter = "Field = 'Value'"
Me.SubFormControl.Form.FilterOn = True