- Joined
- Jan 26, 2010
- Messages
- 2
- Reaction score
- 0
I am maintaining an Access 2003 which was developed by someone else. I would like to create an .MDE file for it but it will not do it. One solution I was given to this problem was to compile the VB code but when I do I get the "Method or data member not found" error for the code for the code in blue
Private Sub Combo90_AfterUpdate()
' Find the record that matches the control.
Dim rs As Object
Set rs = Me.Recordset.Clone
rs.FindFirst "[ID] = " & Str(Nz(Me![Combo90], 0))
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
End Sub
The control Combo90 is still on the form and the code works but why the compile error?
Any help would be deeply appreciated.
Tom
Private Sub Combo90_AfterUpdate()
' Find the record that matches the control.
Dim rs As Object
Set rs = Me.Recordset.Clone
rs.FindFirst "[ID] = " & Str(Nz(Me![Combo90], 0))
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
End Sub
The control Combo90 is still on the form and the code works but why the compile error?
Any help would be deeply appreciated.
Tom