Ask Your Question

Base Form Flow Control

asked 2020-07-01 07:07:16 +0100

gkick gravatar image

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

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2020-07-01 18:08:28 +0100

Ratslinger gravatar image

updated 2020-07-01 18:12:39 +0100


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 ------- C:\fakepath\FixedCascade.odb

edit flag offensive delete link more


wow, thank you!

gkick gravatar imagegkick ( 2020-07-01 18:47:49 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-07-01 07:07:16 +0100

Seen: 40 times

Last updated: Jul 01 '20