Runtime Error 3021 no current record.

[pfm721]

I have a modified version of Allen Browne's search form. When I click the
filter button I get 3021 error. The Debugger takes me to Me.Filter = strWhere
in the code. If I then go and open the query that the form is searching the
query has run correctly based on the paramters. Help...

Thanks

 

[Allen Browne]

Could be several causes for this error. I assume you are talking about this
code:
http://allenbrowne.com/ser-62code.html

Firstly, have you set up a cyclic dependency, where the form's records
depend on the query, and the query depends on something on the form (such as
Forms!Form1!Text16)? That could cause a problem about a current record
disappearing. As published, the utility avoids that kind of circular
dependency.

If your search form allows edits, the error could be caused when a records
cannot be saved. Similarly if it allows deletions, the mesage could be
related to a record that's gone. (This is particularly likely in A2002 SP3.)

It could also be caused by a faulty WHERE clause.