Applying and Clearing Filters

[cwby1966]

I have a filter that is applied on the click of a command button. If you click the button to remove the filter and show all records and then choose to do another filter with a different location you get the same data as the first time is there something I need to do duifferently
I have included the code for both the apply filter and the show all records
Apply

DoCmd.ApplyFilter "fltr_drawingsite", ""
Me!Floor.Requery
 

Me.FilterOn = False
Me!Combo48 = ""
 

Clearing the filter seems to be working

[aprpillai]

User the Filter Property of the Form to Filter Data.

Example to Apply the Filter:

Me.Filter = "EmployeeCode = 1234"
Me.FilterOn = True

To Remove the Filter:

Me.FilterOn = False

will remove the filter. You can run the Code with Command Button or any other appropriate Event Procedures.

[cwby1966]

User the Filter Property of the Form to Filter Data.

Example to Apply the Filter:

Me.Filter = "EmployeeCode = 1234"
Me.FilterOn = True

To Remove the Filter:

Me.FilterOn = False

will remove the filter. You can run the Code with Command Button or any other appropriate Event Procedures.

Thanks for the reply I have tried that and it works exceept the criteria for the filter comes from a combo box.