S
scott
I've used CODE 1 below on the "AfterUpdate" event on a combo box to jump to
the record selected fine using Access.
However, after converting my Access file to an ADP file, I get the error
"Object doesn't support this property or method".
Is there an alternative way via VBA to make my combo "AfterUpdate" event
find the choosen record?
The underlying recordset is a stored procedure if that matters. Also, I
tried using CODE 2 without success.
CODE 1 ********
Dim rs As Object
Set rs = Me.Recordset.Clone
rs.Findfirst "[userID] = " & Str(Me![cmbNameQuickFind])
Me.Bookmark = rs.Bookmark
CODE 2 ********
Me.RecordsetClone.Findfirst "[userID] = " & Me![cmbNameQuickFind]
Me.Bookmark = Me.RecordsetClone.Bookmark
the record selected fine using Access.
However, after converting my Access file to an ADP file, I get the error
"Object doesn't support this property or method".
Is there an alternative way via VBA to make my combo "AfterUpdate" event
find the choosen record?
The underlying recordset is a stored procedure if that matters. Also, I
tried using CODE 2 without success.
CODE 1 ********
Dim rs As Object
Set rs = Me.Recordset.Clone
rs.Findfirst "[userID] = " & Str(Me![cmbNameQuickFind])
Me.Bookmark = rs.Bookmark
CODE 2 ********
Me.RecordsetClone.Findfirst "[userID] = " & Me![cmbNameQuickFind]
Me.Bookmark = Me.RecordsetClone.Bookmark