Remove filter

[jalb]

I have a form that I would like the enduser to be able to filter out a record, make changes, and then be able to Remove Filter, to repeat the process. I currently can only do this by using the icon on the toolbar to be able to remove the filter. Can anyone help with creating a command button to remove the filter, so a new record can be filtered?

[orange]

see http://office.microsoft.com/en-us/ac...001232736.aspx

[jalb]

That did not work. I tried putting a toggle on my form, but that just greys out my page. Here is more specifics.

Open New form
Filter for ClaimNumber
Edit data on form pertaining to that claim number
RemoveFilter
Filter for ClaimNumber
Edit data on form pertaining to that claim number
RemoveFilter

So if I could have a button on the form for the user to click, with these perameters.
Reset Data for your next search

Thank you,
Kim

[alansidman]

Here is a tutorial on how I would do it.

http://www.datapigtechnologies.com/f...tomfilter.html

[jalb]

Hello,

No, this is not what I am looking for, it wanted me to make a combo box, and then a refresh on that data selected. I want to be able to put the cursor in the field, filter the data, then instead of clicking the icon for remove filter, I want it to be a control box on the form that removes the filter, starting fresh.

[orange]

Perhaps you can describe what you want using some sample data.

I'm unclear how you would

put the cursor in the field, filter the data,

what filter would you be using?

What exactly is

a control box on the form

that removes the filter? What event of the "control box" do you intend to use?

I'm thinking you are telling us how to do something and NOT what you want to happen, but perhaps your response will clarify things.

[alansidman]

I didn't realize that you were trying to filter carte blanche. I thought that you would be only filtering on one field. Well, that said, I am not sure that you can turn a filter off with VBA if it has not been turned on with VBA. Having said that, here is some untested VBA to try out.

Put it on a command button in the on Click event

If me.filterOn = True Then
me.filterOn = False
End if