searching a string Help

[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

 

[kathryn]

Do you have a form set up ready to display the records? If so, you can just set a filter on the form. The filter would be something like:

Me.Filter "[Item number] Like *' "&me! [combo2]& "*'"
Me.FilterOn = True

The use of the word Like and the asterisks will set the filter to find records where item number contains the value in the combobox.
Kathryn