Access VBA error: You canceled the previous operation

[Totenkopf]

The code below always give me that error on line "Me.Bookmark = rs.Bookmark" after each selection in a combo box. Currently to circumvent this problem, I have to click "Debug", stop the debugging in vba editor, and then the combo box works as normal like nothing just happened. So this error pops up every time I load the form for the first time and tried to select something.

How do I fix this?


Thanks



Private Sub cbWeek_AfterUpdate()

Dim rs As ADODB.Recordset
Set rs = Me.RecordsetClone

rs.Find "[id] = " & Me.cbWeek.Value
Me.Bookmark = rs.Bookmark

End Sub

 

[TomCologne]

Try setting a default value for 'cbWeek'.

TomCologne