Clearing Filters

[syztemlord]

I have serveral filters I use on my form,
example:
Private Sub customer_Click()
Forms!customers.RecordSource = "Enter_Customer"
FilterOn = True
End Sub

I would like to add another button that clears all the filters and allows me to view all the data again.

I have tried using "Me.FilterOn = False" not sure if this is what I need, but this dosen't do anything anyway.

Can anyone help?

 

[Dennisk]

use Docmd.ShowAllRecords

 

[syztemlord]

I tried the "DoCmd.ShowAllRecords" but when I have done a search then click on the clear filter button, I get the query search window up again.

 

[syztemlord]

Is there anyone who can help with this? I'm sure it's something very simple but as a noobie to Access I'm starting to loose the will to live!

Please help!

 

[KeithG]

The FilterOn property should do the trick. Are you using query parameters not form filters, maybe?