Using Search to filter

Using Search to filter

Hi,

In my Elections application on the 'Aicent Elections' form there is a field called 'Election'. This field is a formula field that is created by concatenating the 'Elected Operator' and 'Electing Operator' fields together.

I do this because any given operator, O2 Germany for example, can be either an Elected Operator or an Electing Operator, so if I want to show all the records that contain O2 Germany then I have to use the Search function on the Election field rather than use a standard filter.

The problem I have is that if I use Search to show all the records containing O2 Germany then as soon as I update one of the records the Search filter is removed and all the records are displayed, so I have to Search again.

This makes life very tedious if I have to make a number of updates for one customer.

Can you change it so that the Search filter remains in place after an update please?

Thanks,

Lee