Search results

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 =...