I have a form (main) that has a query as the recordsource. On this form, I have a command button that opens another form (administration) giving a user some options. One of them is a check box that, when checked, makes a subform on the main form visible. I would like the subform to become visible immediately when the box is checked. Everything works fine if the form is loaded, but I want to prevent the user from having to reload or use the "Refresh All" button on the ribbon. What would be the best solution?