0

Hello,
I am having an issue with a data filled combo box. I can not put my finger on why it is giving me the "run-time error 424 object required" error. The code is simple and the data is there.

Dim sSql As String
    Set rsMfg = New ADODB.Recordset
    sSql = "Select SourceID, [Source Name Code] AS sc From Source Order By [Source Name Code]"
    Set rsMfg = New ADODB.Recordset
    rsMfg.Open sSql, caConn, adOpenStatic
    Do While Not rsMfg.EOF
        cboWSaler.AddItem (rsMfg!sc)
        cboWSaler.ItemData(cboWSaler.NewIndex) = rsMfg!SourceID
        rsMfg.MoveNext
    Loop
    rsMfg.Close
    Set rsMfg = Nothing

Any ideas on this will be greatly appreciated.

Thanks

Edited by ProfessorPC: n/a

1
Contributor
1
Reply
2
Views
6 Years
Discussion Span
Last Post by ProfessorPC
0

The reason for the error was a typo. I am not sure why this was moved to the VB.NET because it is VB6

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.