Base Form Flow Control

edit

Gday, I have a form with 5 listboxes of which 4 are cascaded, narrowing down records for reports by way of a filter table. All working fine but the process flow is clumsy because after every selection from a listbox, a refresh needs to be performed which in turn prompts to save. What would be the choices to automate either the refreshes and how to stop the repetitive safe prompts. A mockup is in the attachment.C:\fakepath\CascadeListboxes.odb