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.CascadeListboxes.odb
Hello,
With each list box on the same form and each button refreshing the form, the partial Filter record was needing to be saved. Placing the subsequent buttons and list boxes on cascaded sub forms fixes the problem.
Sample ------- FixedCascade.odb
wow, thank you!