How can I filter a form using multiple records within a field?

Question

Say I have a field named Project and within that field I have multiple 6 digit numbers. I have a form that has all the records showing all the different 6 digit numbers but now I only want the form to show all the records with a project number of '123456', '012345', '63*', and '121212'. How can I add a filtering option?

Answer 1

Just FYI, crossposted here...

Microsoft Community

Answer 2

You can OR the values together. Say you have some values sitting in txt1 through 4
... " where Project like " & Me.txt1 & " or Project like " & Me.txt2 ... etc.