<div>
Sorry, the above assumes you have 2 controls named StartDate and EndDate on the form.
</div>


Sorry, the above assumes you have 2 controls named StartDate and EndDate on the form.

<div>
Tom,<br />
<br />
This worked great! &nbsp;Thanks for your help.<br />
<br />
I'll get back with you on the other one tomorrow ...<br />
<br />
Sam
</div>


Tom,

This worked great!  Thanks for your help.

I'll get back with you on the other one tomorrow ...

Sam

<div>
<div class="content wysiwyg-content">
Greetings,<br />
<br />
Well, I'm having another filter problem ...<br />
<br />
I'm trying a docmd.applyfilter to a form based on user input to that same form. &nbsp;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. &nbsp;Unfortuantely, I get run time error 2501: &nbsp;applyfilter action canceled. &nbsp;I guess I'm not understanding something here, but I thought I could do this kind of thing.<br />
<br />
Anyone have any ideas?<br />
<br />
Thanks in advance!
</div>
</div>


Greetings,

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!

Access 2000:  ApplyFilter action canceled

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.