Button to add or remove table filters and button to refresh table

**cmorten82** · 04-09-2015, 07:52 PM

I need a code that I can add to a Button (Form Control) that will remove or add the filters to a table. I also need a code to add to a button to refresh the table.

**alansidman** · 04-09-2015, 09:01 PM

Look at this link for the refresh syntax

https://msdn.microsoft.com/en-us/lib.../ff838648.aspx

We will need more information on the other issue. Range of the table/range you wish to filter/unfilter, etc.

**cmorten82** · 04-10-2015, 11:26 AM

My apologies I failed to mention I know pretty much nothing about VBA. I right clicked on my button and went in to view code and the following is displayed: :"Private Sub CommandButton1_Click()" and then a space and then "End Sub" Do I place "Workbooks (3). RefreshAll between these? What am I missing? As for my other issue the Range of my Table is A4:O15000. I'm not sure if it will matter but this particular table is from a data connection to my Access Database. Thanks