Could someone shed some light as to why the following error occurs?:
"Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record."
I am working with an Access Project (Access 2000) setting with a SQL server backend.
This occurs in the following lines of code (which is auto generated by the Access wizard for list boxes that "find a record when a value is selected"; this is also located on a subform), with the line in orange causing the error:
Dim rs As Object
Set rs = Me.Recordset.Clone
rs.Find "[ISOPersonNumber] = " & Str(Me![subfrmISOEditEntryListBox])
Me.Bookmark = rs.Bookmark
It seems to occur when the list box on the subform is repopulated with new data (via the rowsource property of that list box).
Any help appreciated. Thanks,
Nishant
"Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record."
I am working with an Access Project (Access 2000) setting with a SQL server backend.
This occurs in the following lines of code (which is auto generated by the Access wizard for list boxes that "find a record when a value is selected"; this is also located on a subform), with the line in orange causing the error:
Dim rs As Object
Set rs = Me.Recordset.Clone
rs.Find "[ISOPersonNumber] = " & Str(Me![subfrmISOEditEntryListBox])
Me.Bookmark = rs.Bookmark
It seems to occur when the list box on the subform is repopulated with new data (via the rowsource property of that list box).
Any help appreciated. Thanks,
Nishant
