Dynamic Search - Help Needed

[Kit]

Hi,

I'm new to access and stumppled across a post by John Big Booty for a "Dynamically search multiple fields ".

I've changed ti about to suit my needs but I have borken the search on change function.

I was wondering if anyone could explain what I've done wrong and explain how I can fix it.

Thank you,

Kit

P.s this is my first post please advise if I have done anything wrong?

 

[Severin]

Well you could change your query1 to:

SELECT TBL_All.[SAP Code], TBL_Team.Team, TBL_All.Explanation, TBL_All.Teams
FROM TBL_All INNER JOIN TBL_Team ON TBL_All.TeamID = TBL_Team.TeamID
WHERE (((TBL_All.Teams) Like "*" & [forms]![FRM_SearchMulti]![frame43] & "*") AND (([sap code] & " " & [Team] & " " & [explanation] & " " & [teams]) Like "*" & [forms]![FRM_SearchMulti]![SearchFor] & "*"));