Combo Box
 

It looks to me like you took this code from Access. In Access, Me would
refer to the form that the combobox is on, and an Access form is a totally
different beast than an Excel userform. So unless you did this deliberately
and brought the Access object model into your Excel project, Excel cannot
make sense of the objects and methods you are trying to use. An Excel
Recordset applies only to a Querytable or PivotCache.
If you explain what you are trying to accomplish with your combobox perhaps
I or someone else here can give some other ways to do it.
--
- K Dales


"Old Music Lover" wrote:

I have a combo box with the following "after update" code. I get a Type
Mismatch message on the

Set MeClone = Me.RecordsetClone statement. Any clues as to what I have
done wrong? It also does not recognize the NoMatch on the MeClone.

Private Sub NAME_SELECT_Change()
Dim SearchValue As String
Dim MeClone As Recordset
Set MeClone = Me.RecordsetClone
Let SearchValue = Me![NAME_SELECT].Value
MeClone.Find "[EMPLID] = " & SearchValue
If Not MeClone.NoMatch Then
Me.Bookmark = MeClone.Bookmark
End If
MeClone.Close
End Sub