Hi All,

I am using VB6 and connecting to my DB using DAO

I am trying to create a search wherby a user would input say 3 letters in to a textbox and the resulting matches would populate a msflexgrid.

For example, if he types in 'sic', then this would find 'basic force gauge' from the gauges table.

I have used the code below and although i have used the Like command, the search brings up 0 records. Yet i know that there several matches to the query.

Can you have a look at the query. I'm sure this is where the problem is, but not sure how to correct6

Many Thanks



strSQL = "Select Instrumentdescription, Instrumennumber From GAUGES where Instrumentdescription Like '" & Text1.Text & "'"
Data1.RecordSource = strSQL
Data1.Refresh
Data1.UpdateControls