Updating Queries

Hi, 2 questions regarding the updates of Queries...

I have been redoing some of my spreadsheets as of late, and one of the sources of information that my spreadsheet uses has changed from a static data file that I had to download and have my spreadsheet reference it to a JSON file

Now the Json Data is not a big deal, I just used excels query from web sources function since you can read the output as a json file now... so getting the data is not the problem

What is the problem is that the data is rather large, and if need be I can let my workbook pull the data every time I log in but I would much rather have it set up so that it only refreshed the data from said query when say so... I was thinking of just putting an activex button on a sheet that has the refresh command in it when pressed.... and that being the only time that particular query gets refreshed...

Having said that I do have queries that will need to be refreshed very often... so I cant just turn off all refreshing, I need to be able to do it with just a few of my workbooks queries.

Is this possible? WHich brings me to my second question... what would be the best way to refresh a single query on command? I had always used the .refreshall in a command button but now that I have more queries I would rather not do that....

would it be best to take the json query and define it as a function and then refresh that function?

Thanks for your help.

You refresh the object only.
If its a combo, cboBox.requery.
If the whole form, me.requery.

So how exactly do I do that with a query I made through the data tab... Im not sure what sort of object it would be other than a query I named listregions

heres the code in the advanced editor

Please Login or Register  to view this content.

Do I simply declare it something before that code? like (listregion) =>

or what should I do? sorry my knowledge is lacking in this area... some areas I am good at some areas I am not so much

Thanks