'You cancelled the previous operation' (Access 2002)

[RichA]

When I use the following code, 2 out of three times, it works fine and filters the form to the field specified, but occasionally I'll get a Run time error 2001: You canceled the previous operation.
Any thoughts? I'm kind of puzzled as to why it works sometimes, and not others.

Private Sub cboProjectNumber_AfterUpdate()
On Error GoTo Err_cboProjectNumber_AfterUpdate
Dim sql As String
Dim Fieldname As String
Dim FieldValue As String
Fieldname = "PROJECT_NUMBER ="
FieldValue = cboProjectNumber.Value
sql = Fieldname & Chr(34) & FieldValue & Chr(34)

Forms!frmProjectDetail.Filter = sql
Forms!frmProjectDetail.FilterOn = True

Exit_cboProjectNumber_AfterUpdate:
Exit Sub

Err_cboProjectNumber_AfterUpdate:
MsgBox Err.Description
Resume Exit_cboProjectNumber_AfterUpdate

End Sub

Thanks in advance for any feedback. This one's been bugging me for a while.

Rich

[johnhutchison]

I think that sometimes the value of the sql string can't be used for a filter.

Presumably Project_number is a string. Does it sometimes have unusual characters in it?

Try adding a msgbox line to inspect the value of sql and see if you can see a pattern in the failures.

sql = Fieldname & Chr(34) & FieldValue & Chr(34)
msgbox(sql)
Forms!frmProjectDetail.Filter = sql

[charlotte]

You can also get this error when a couple of events collide. For example, if the form is in edit mode when you try to change the filter, you might get this error.