Reloading the page won't do anything. The form needs to submit, store the field value you selected, then reload so the second query can use the new value through substitutions. So they need to edit the field and save their profile then go back to edit their profile to see the change.
There are plans to implement ajax updating of query select fieldtypes, but for now there is no such functionality. I've added a feature ticket to look into implementing this in a future release.
forge.joomlapolis.com/issues/5761
CB Auto Actions can not help you here. Additional code is needed in CB Query Field for this to work.