Hi
This solution is based on your previous database.
The form that opens is set as a Split Form and there is an Unbound Textbox in the header.
Just type the data you want to filter by and hit Enter and it will filter for that data.
The Clear Command button returns all data.