Microsoft KB Archive/259548

= BUG: DataCombo Control Does Not Work on VBA User Forms =

Article ID: 259548

Article Last Modified on 1/11/2001

-

APPLIES TO


 * Microsoft Visual Basic for Applications (VBA) Software Development Kit (SDK) 5.0
 * Microsoft Visual Basic for Applications (VBA) Software Development Kit (SDK) 6.0
 * Microsoft Visual Basic for Applications (VBA) Software Development Kit (SDK) 6.1
 * Microsoft Visual Basic 5.0 Professional Edition
 * Microsoft Visual Basic 6.0 Professional Edition
 * Microsoft Visual Basic 5.0 Enterprise Edition
 * Microsoft Visual Basic 6.0 Enterprise Edition

-



This article was previously published under Q259548



SYMPTOMS
When trying to use a Microsoft DataCombo control on a VBA User Form, the following error messages may occur:

Method or Property not found.

-or-

Invalid procedure call or argument.



STATUS
Microsoft has confirmed that this is a bug in the Microsoft products that are listed at the beginning of this article.



Steps to Reproduce Behavior
 Start with a blank VBA User Form. Add the following ADO (not DAO) controls to the VBA toolbox:  Microsoft ADO Data Control, version 6.0 (OLEDB) Microsoft DataCombo Control, version 6.0 (OLEDB)

 Drag an ADO Data control onto the user form.</li> In the Properties window of the ADO Data control, select the button of the ConnectString property, and then create a ODBC data source connection to a database.</li> Drag a DataCombo control (ADO type) onto the form.</li>  Add the following code: Private Sub UserForm_Activate Set DataCombo1.RowSource = Adodc1 End Sub </li> Run the User Form and note that the following error message is displayed:

Method or Property not found.

The same steps work fine on a Visual Basic User Form.</li></ol>

Keywords: kbbug kbpending KB259548

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.