Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
linking a form combo box... results from the combo box to another | Excel Discussion (Misc queries) | |||
combo reference on another combo box for picking address etc. | Excel Worksheet Functions | |||
In Excel I need to set up a combo box based on another combo box. | Excel Discussion (Misc queries) | |||
"Combo Box - getting control combo box to stick in place in worksh | Excel Discussion (Misc queries) | |||
"Combo Box - getting control combo box to stick in place in worksh | Excel Discussion (Misc queries) |