Mulitple word search in single field

[Lowell]

I have attached the db.

I only tried the code offered by June7

I wasn't sure where to attach the last code offered on this forum thread.



Recipe Database - Copy.zip

[orange]

You have posted only part of your FrontEnd/Backend set up.
All links are failing.

[Lowell]

Recipe Database_be - Copy.zip

Here is the rest of it, sorry. I missed that.

I hate it when people waste my time when i try to help them and now I'm doing it to you.

Sorry!!

[orange]

I see your switchboard is all embedded macros. I'm not familiar with them so will leave this to others.
I was trying to see the code behind recipe searches.

[Lowell]

The code is only on the ingredient search

The other searches I have figured out cause they are basic

[Lowell]

And I tried to do as was mentioned in the one link in June7's post.

qryIngredSearch
Form1
Report1

I try to stick to naming conventions, but miss it sometimes

[Lowell]

oops that didn't quite post right,

The three access objects mentioned in previous post are the objects related to the ingredient search.

[June7]

Why does the listbox RowSource have the Ingredient field twice? Weird, even after I fix that the listbox does not show anything so I deleted it and created a new listbox. That one works!

Need the Comments field in qryIngredSearch.

Need to remove 's' from Ingredients in this code:

strWhere = "[Ingredients] IN (" & Left$(strWhere, lngLen) & ")"

[Lowell]

I managed to finally get it to work!

Took me awhile.

Thanks everyone for your input and patience!

Thanks June 7 for taking a look and suggesting the fixes!