BUG: DataCombo Control Does Not Work on VBA User Forms (259548)


The information in this article 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 Professional Edition for Windows 5.0
  • Microsoft Visual Basic Professional Edition for Windows 6.0
  • Microsoft Visual Basic Enterprise Edition for Windows 5.0
  • Microsoft Visual Basic Enterprise Edition for Windows 6.0
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.

MORE INFORMATION

Steps to Reproduce Behavior

  1. Start with a blank VBA User Form.
  2. 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)

  3. Drag an ADO Data control onto the user form.
  4. 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.
  5. Drag a DataCombo control (ADO type) onto the form.
  6. Add the following code:
    Private Sub UserForm_Activate()
    Set DataCombo1.RowSource = Adodc1
End Sub
  7. 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.
Modification Type:MajorLast Reviewed:1/11/2001
Keywords:kbbug KB259548
©2002 Microsoft Corporation. All rights reserved.