G'day people.  I'm a newbie to all this and my problem is probably the most
basic there is.  (Please don't laugh).

I am using VB5.0 as a front end for a MS Access 97 database.  I am trying to
search by a ID no and then extract the text in another field of that record.
How do I get the SQL to work?

My version didn't have proper help files but it is still the Enterprise Ed.

Thanks
Matt

Use something similar to :-

"SELECT [TextFieldName] FROM [TableName] WHERE [ID] LIKE '" & SearchCriteria
& "*'"

This will search the table for the id code starting with the selection
criteria and return only the textfield that you require.

Hope this helps.

Regards

Ian Ashworth