SQL

[CoMMiE]

Hi
Whats wrong with the following SQL statement i got a object require error out of it everytime i click on dbcombo

Private Sub DBCombo1_Click(Area As Integer)
  Data2.Recordset.FIND DBCombo.ListField & " = " & DBCombo.Text

end sub

Any suggestion or help will be greatly appreciated
Thanks

[parksie]

Change DBCombo to DBCombo1.

PS - that's not a SQL statement
SQL statements look like this: "SELECT * FROM MyTable WHERE MyStringField='Hello';"

[BruceG]

... and shouldn't the method be "FindFirst"?
BTW, the argument given to a "FindXXXX" method is like a SQL "WHERE" clause without the word "WHERE".

[VBonliner]

Maybe you have this code in another form from where
Data2 is.


Try this

Data2Form.Data2.RecordSet.FindFirst...

[CoMMiE]

Thanks for pointing out the error guys
I will try to fix the code and see how it turns out


Thanks