Help with code for textbox search

[Gregm66]

Hi all,

I have a textbox that I want to search a field in a table for what ever Ingredient is typed into the textbox, then populate a combobox with all the recipe names that have that Ingredient in them.

I am using the code below but it keeps giving me an error



Any help on this would be appreciated.

Private Sub CmdSearch_Click()
    Me.txtSearch = DLookup("Table1", "rcpIngredients", "RcpName = CmbSearch")
End Sub

[ranman256]

Don't use Dlookup, use the textbox in a query, then open the query.
Docmd.openquery "qsFind"

the qry:
select * from table where field like "*" & forms!frmFind!txtFind & "*"

[Gregm66]

thanks for the reply ranman256,

I will try that way and see how I go.

thanks again