Runtime Error 3021 no current record.

  • Thread starter Thread starter pfm721
  • Start date Start date
P

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
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unexplained run-time error 3021 3
Allen Browne Search 3
Filter Report based on forms filter 2
Allen Brownes ECount() 5
Error 3021 when trying to store bookmark 8
Allen Browne's Search Form - Debugging help needed 2
runtime 3021 3
Runtime Error 3021: 'No Current Record' 2

Back
Top