Search results

Thanks but this results in no current record so I guess I'm not implementing it correctly. Me.Filter = "[Surname] LIKE '"" & lastStr & ""*' And [First Names] LIKE '"" & firstStr & ""*'"

I either get errors when the code runs or it just results in no current record for any search. I am not sure where to place them correctly so have played around quite a bit but none of what I have tried works.

I've had a play around with double and double-double quotes and char(34) etc. but nothing seems to be working.

Sorry to open this up again but I have hit a snag. The code is working great apart from one issue. If I search a name such as Paul O'Callaghan by typing "o'c pa" I receive a Run-time error. It says Syntax error (missing operator) in query expression '[surname] LIKE 'o'c*' And [First Names] LIKE...

Thanks for your quick reply. Post edited. Just tried and works perfectly.

I have a field for first and last name. I can currently filter records based on last name. I want to make it so I can also type in the first name or initial after the full or part of the surname and it will filter appropriately. e.g. Paul Clarke would be shown if I typed “Cla Pa” and clicked...

Thank you for your reply. It has helped me understand what is going on. I still can't get me.filter to accept the 2 datepart functions. Even passing the strings into me.filter doesn't work. I really don't understand where to place brackets etc so I think this may be the problem. I have tried...

Please help This works: Me.Filter = "DatePart(""m"", [due date]) =" & Me.Combo382 This also works (but obviously sets the dates to match march 2014): Me.Filter = "DatePart(""m"", [due date]) = 3 And DatePart(""yyyy"", [due date]) = 2014" This however does not work: Me.Filter =...