Como box search

[FJM]

I have the following search which looks for any part which is called up in the combo box.
[Forms]![INSPECTIONSHEET]![Combo25]
Is it possible to amend this so I can look for any part which contains the details of the combo box but does not necessarilt match it
For example:-
If the combo box says ABC123 I will find all of those results
Can I amend the code so that it will now also find the record ABC123, ABC124


I know the * wildcard exists, but can it be used in this instance

[ranman256]

The wildcard only looks for the text you enter
searching ABC123*
will NOT find ABC124
tho ABC12* will

put ABC12 in the text box
run the query that has this sql
select * from table where [field] like *" & forms!frmFind!txtBox & "*"

[FJM]

The snapshot above shows how the combo is being used.I understand the power of the * when using as a search tool. What I don't know is what change to make to the code shown above so it will then use the code you suggest.