Finding Records [resolved]

Does any1 out there have a way to find records based upon the first letter of a value in one of the DB's fields?

I am using ADODB...

For example:
I have a text field that may have the following values...

Bob
Mary
jim
Joe

if my user selects "J" from a combo box, i would like to have a list box fill up with "jim" and "Joe" from the Database...


Thank you for your help,
Squirrelly1

You can do something like this

VB Code:

Query = "SELECT * FROM TableName WHERE [Name] LIKE '" & combobox & "%'"

Thanx for the help Maldrid, I was playing around with that but couldn't get the right syntax... ;)



Squirrelly1 :p

So you have it working now right?