serach for records with data control

[ayouni]

I would like to search in Microsoft access database for specific records, and the result must be in dbgrid.

I am using :
Data1.recordsource = "SELECT * from Information where Age >= '" & textsearch.text & "'"
Data1.refresh

When i use this, a message is showing : Type incompatible...

Thanks.

 

[Spellman]

If Data1 is your data bound control then try:

"SELECT * from Information where Age >= " & textsearch.text

I'm assuming age is a numeric field???

Mark

The key to immortality is to make a big impression in this life!!