Clear Form Fields

[Dilly]

I have a Form in a datasheet view. The data is presented with the fields across the screen and records continous down the page. I am trying to get the fields to all be cleared when i select the Filter by Form Icon

 

[LittleSmudge]

Thats an interesting one because it always DOES for me.

The question I'd ask is -
Are you really hitting the Filter-By-Form tool
OR
the Filter-By-Selection tool which leaves one record visible
OR
the Apply Filter tool which will show as amny records are are applicable to the currently stored filter ?


G LS

 

[Dilly]

I am selecting the Filter by Form, it clears all records but sometimes leaves old filter data in some of the fields. I want this data to be cleared, so that the filter starts a fresh each time. The users of the database cannot understand any thing out of the ordinary, which means creating a form as simple as possible