Invalid use of NEW keyword

[JPRoy392]

Am I missing something or has my brain taken a early holiday?

Dim rstCountry As Recordset
Set rstCountry = New Recordset

how can "New Recordset" be bad?
(Invaild use of new?)

I need a vacation.

[Jop]

Try this mate:

Dim rstCountry As New Recordset

[JPRoy392]

I tried that too. Didn't work before. I think that I may have some setting wrong or something.

[kedaman]

Recordset is probably public not creatable

[JPRoy392]

nope it's Private

Private Sub FillCountryCombo()
Dim rstCountry As New Recordset
'Dim rstCountry As Recordset
'Set rstCountry = New Recordset
    rstCountry.Open "SELECT DISTINCT Customers.Country FROM Customers ORDER BY Customers.Country", m_conn, adOpenForwardOnly, adLockReadOnly
    cboCountry.Clear
    cboCountry.AddItem ""
    Do Until rstCountry.EOF
        If Not IsNull(rstCountry![Country]) Then cboCountry.AddItem rstCountry![Country]
        rstCountry.MoveNext
    Loop

End Sub

Still blows up

[kedaman]

Hmm, now i don't get it. Are you the designer of Recordset (sounds like database stuff and i don't know much about them). Because a private class wouldn't be available outside it's project..
Or do you mean the object is private? Sorry for not being a db expert :/ or whatever

[Serge]

If you have multiple libraries then you would have to specify what library you're using:

Dim rs As New ADODB.Recordset

[JPRoy392]

Thank you both for the help. I forgot "ADODB." in front of th word recordset (Thanks Serge). Can you tell me the difference, so I don't do that again (If you have the time)?

Thank you everyone and happy holidays!

[Violenza]

I think he means there are multiple libraries referenced in your project that have something defined as a 'Recordset'

you can see your project references in the program menu, Project | References

Since they are both loaded, you have to qualify which library the recordset you want to use belongs to.

Dim rs as new ADODB.recordset explicitly tells VB which definition of recordset to use.

Your error sounds like VB was trying to use the other definition of recordset which was not an object that can be instantiated via the new operator