Close an Open Form in Microsoft Access using the DoCmd.Close VBA Command and an OnClose Event

Поделиться
HTML-код
  • Опубликовано: 6 окт 2024
  • In this video I'm going to teach you how to close one form when another is closed. It involves ONE line of VBA coding, but don't be afraid. I'll show you exactly how to do it.
    Claudia from Henderson, Nevada (a Platinum Member) asks: I have a couple of "additional info" forms that I can open for a customer, such as their contacts, orders, service calls, etc. I like to keep these as separate forms much like you do in your Free Customer Template. It's a pain to have to close them all individually whenever I'm done with a customer. Is there a way to link them all so they close whenever I close the customer form?
    BONUS FOR MEMBERS:
    Silver Members and up get access to an Extended Cut of this video. Members will learn how to loop through ALL open forms and close them, except for the Main Menu form.
    MEMBERS VIDEO:
    • Close an Open Form in ...
    BECOME A MEMBER:
    RUclips: / @599cd
    or My Site: 599cd.com/THMe...
    LEARN MORE:
    599cd.com/Clos...
    LINKS:
    Tesla Story: 599cd.com/Tesla
    DoCmd.Close in Access Developer 11: 599cd.com/acd11
    COURSES:
    FREE Access Beginner Level 1: 599cd.com/Free1
    $1 Access Level 2: 599cd.com/1Dollar
    FREE TEMPLATE DOWNLOADS:
    TechHelp Free Templates: 599cd.com/THFree
    Blank Template: 599cd.com/Blank
    Contact Management: 599cd.com/Cont...
    Order Entry & Invoicing: 599cd.com/Invo...
    More Access Templates: 599cd.com/Acce...
    ADDITIONAL RESOURCES:
    Get on my Mailing List: 599cd.com/YTML
    Contact Me: 599cd.com/Contact
    TechHelp: 599cd.com/Tech...
    Paid TechHelp Questions: 599cd.com/Tech...
    Consulting Help: 599cd.com/Cons...
    Twitter: / learningaccess
    en.wikipedia.o...
    products.offic...
    microsoft.com/...
    KEYWORDS:
    microsoft access, ms access, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #instruction, #learn, #lesson, #training, #database, onclose, on close, on close event, close form, closeform, close all open forms, loop through forms, loop through all forms, close all forms
    QUESTIONS:
    Please feel free to post your questions or comments below. Thanks.

Комментарии • 11