MS Access (Open, Load or Current)

Posted on 2009-04-22
Last Modified: 2013-11-28
This is more of a general question...
I know that the form procedure for reading code is:
Open ’ Load ’ Resize ’ Activate ’ Current

I have a main form -- this is closed when some of my smaller forms are opened because I wanted to be able to refresh the main form when it's re-opened.

Is this optiminal? Or should I skip using code in the Open and move it to Load or Current instead?
Thanks, Stacy
Question by:stacydr
    LVL 7

    Expert Comment

    have you  tried   mainform.requery?   instead  of closing the  main  form?

    LVL 2

    Author Comment

    I was thinking of removing the close feature and adding the requery in the Current event?
    What do you think?
    I'm just trying to have the smoothest flow..
    LVL 7

    Accepted Solution

    yes  removed the closing of the form..     then  set the  smaller forms  modal  value  to they can't get back to the main form  without  closing the  mini-forms  first..

    if you're  going  to use  this. better  use  OnActivate or GetFocus method of the mainform,, then  requery it..
    LVL 2

    Author Closing Comment

    thanks = sorry for the delay

    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    Today's users almost expect this to happen in all search boxes. After all, if their favourite search engine juggles with tens of thousand keywords while they type, and suggests matching phrases on the fly, why shouldn't they expect the same from you…
    Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
    Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
    In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

    746 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

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now