help with finding part of a string 1

[Travis33]

I have a combo box that finds the record that I type in
this is the code I placed in the after update event

dim rs as object
set rs = me.recordset.clone
rs.findfirst "[Item number] = ' "&me! [combo2]& "'"
me.bookmark = rs.bookmark

This code works fine but I want to be able to type in part of the string and have it display alist of records that have
this substring in it.

can someone please help.

Thank You,

Travis

 

[Mongooses]

Have you tried using the LIKE operator?
For Example:
Dim strCriteria as String

strCriteria = "[Item number] = '" &me![combo2]& "'" Like "'" &me![combo2]& "*'"

rs.FindFirst strCriteria

Not sure it will work but it might

JC