P
Paul Martin
Hi,
Can anyone advise the best way to filter a subform from the after_update
event on a combo-box. The main form is unbound, the subform is bound as it
displays multiple records. I've tried changing the recordsource, but this
stops me closing the form again(?) and I've tried using DoCmd.ApplyFilter,
but can't get this to do anything other than produce an error message ("The
action or method is invalid because the form or report isn't bound to a
table or query").
Any help would be greatly appreciated.
Regards,
Paul Martin
Can anyone advise the best way to filter a subform from the after_update
event on a combo-box. The main form is unbound, the subform is bound as it
displays multiple records. I've tried changing the recordsource, but this
stops me closing the form again(?) and I've tried using DoCmd.ApplyFilter,
but can't get this to do anything other than produce an error message ("The
action or method is invalid because the form or report isn't bound to a
table or query").
Any help would be greatly appreciated.
Regards,
Paul Martin