Hi
I am having a problem with a subform. I use the filter on the form to get hold of certain records.
But for some reason the filter only works for a while (no pattern), then when I use the filter nothing comes up.
I then every time need to open the form in design view, select propperties > data, and delete the contents of Filter.
After I have done that , it works fine..untill the next time it happens.
Does anyone know what could be causing this and how to FIX it?
Thanks
I am having a problem with a subform. I use the filter on the form to get hold of certain records.
But for some reason the filter only works for a while (no pattern), then when I use the filter nothing comes up.
I then every time need to open the form in design view, select propperties > data, and delete the contents of Filter.
After I have done that , it works fine..untill the next time it happens.
Does anyone know what could be causing this and how to FIX it?
Thanks