SQL

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

Code:

---

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

Change DBCombo to DBCombo1.

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

... 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".

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


Try this

Data2Form.Data2.RecordSet.FindFirst...

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


Thanks