Well, I'm having another filter problem ...
I'm trying a docmd.applyfilter to a form based on user input to that same form. I've coded the applyfilter in the afterupdate event of a control on the form so that after then user enters the data the filter is executed. Unfortuantely, I get run time error 2501: applyfilter action canceled. I guess I'm not understanding something here, but I thought I could do this kind of thing.
Anyone have any ideas?
Thanks in advance!