[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


How to duplicate "Refresh All"? on a Microsoft Access form

Posted on 2011-05-10
Medium Priority
Last Modified: 2012-05-11
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?
Question by:Harry Batt
  • 2

Expert Comment

ID: 35735803
Use a toggle button seperate from your recordset sub.
LVL 77

Expert Comment

ID: 35736183
I assume you are using the Visible property on the subform container control on the main form, to set the visibility.

So in the afterupdate event procedure of the relevant checkbox you do...

forms!mainformname!subformcontainercontrolname.visible = true

LVL 77

Accepted Solution

peter57r earned 2000 total points
ID: 35736212
Well I guess you should add a test..

forms!mainformname!subformcontainercontrolname.visible = me.checkboxname

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever visit a website where you spotted a really cool looking Font, yet couldn't figure out which font family it belonged to, or how to get a copy of it for your own use? This article explains the process of doing exactly that, as well as showing how…
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

872 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question