reset or clear filters button

[kevin19]

i have created a multi field search form that comprises of combo boxes and text boxes. When I run the query everything's great!
I created a button to remove all the filters using DoCmd.RunCommand acCmdRemoveAllFilters but I got error msg saying that the command is not available at present! I am using MS Access 2007
Can someone please help me find an alternative solution? Thanks!

 

[Alansidman]

Attach this code to a command button:

me.yourtextboxnames.value=""
me.requery

 

[kevin19]

Your help is greatly appreciated! It works perfectly! Thank you very much!!!