I have several forms within my Access 97 application that use an unbound combo box to find a record on the form. I keep getting the following error...
"Compile error: Method or data member not found" (referring to
Set rs = Me.Recordset.Clone) The problem appears to be at .Recordset
I found the following information online which appears to relate to this problem.
"A SERIOUS bug has surfaced in Access 97 that can potentially corrupt user databases without users being aware of it.
The bug affects Access 2, Access 95, and Access 97.
The bug can potentially cause edits to a record to be applied to a different record, which effectively corrupts the data in both of them. It appears that it only happens to Access database applications that rely on VBA programming, where an unbound Combo Box is employed in form view to navigate between records with the RecordsetClone and Bookmark commands, a fairly common programming technique. A detailed explanation of the bug can be found at http://odyssey.apana.org.au/~abrowne/BugBookmark.html.
The workaround: go to Access's Design View, right click on Combo Box and enter me.requery into the dialog box, and click Save.
Microsoft says a code fix will be included Service Release 2 for Microsoft Office."
I use both Access 2000 and Access 97. Have no problem with this code in 2000, but am desperate to fix this issue in my 97 applicaton.
Since the suggested workaround did not solve the problem, any ideas or help would be greatly appreciated.
"Compile error: Method or data member not found" (referring to
Set rs = Me.Recordset.Clone) The problem appears to be at .Recordset
I found the following information online which appears to relate to this problem.
"A SERIOUS bug has surfaced in Access 97 that can potentially corrupt user databases without users being aware of it.
The bug affects Access 2, Access 95, and Access 97.
The bug can potentially cause edits to a record to be applied to a different record, which effectively corrupts the data in both of them. It appears that it only happens to Access database applications that rely on VBA programming, where an unbound Combo Box is employed in form view to navigate between records with the RecordsetClone and Bookmark commands, a fairly common programming technique. A detailed explanation of the bug can be found at http://odyssey.apana.org.au/~abrowne/BugBookmark.html.
The workaround: go to Access's Design View, right click on Combo Box and enter me.requery into the dialog box, and click Save.
Microsoft says a code fix will be included Service Release 2 for Microsoft Office."
I use both Access 2000 and Access 97. Have no problem with this code in 2000, but am desperate to fix this issue in my 97 applicaton.
Since the suggested workaround did not solve the problem, any ideas or help would be greatly appreciated.
