Results 1 to 5 of 5
  1. #1
    Frank2306 is offline Novice
    Windows 8 Access 2013 32bit
    Join Date
    May 2017
    Posts
    3

    Navigation subform event firing

    Database Version: 2013



    Database setup: I have a vertical left Navigation Form with multiple tabs. Each tab has a form that is bound to its own table.

    Problem: A user is entering data on one tab1, then clicks on tab2, the record from tab1 is stored with incomplete data

    What I have tried: prompting a simple msgbox to fire on both the "NavigationForm>NavigationSubForm>MyForm" events and the "NavigationForm>NavigationSubform" events to find out where I could code the solution. It seems the order of events are not the same as a regular form/subform setup. So far the only one that seems to fire is the "NavigationSubform OnExit" event. But I cant seem to find a way to get the vba to reference the form inside the navigation subform container to test if its dirty and cancel the new record.

    This is my first time posting in an access forum, be gentle

  2. #2
    aytee111 is offline Competent At Times
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    As soon as a form loses focus the data is uploaded to the table. So by going to another tab the data will be updated.

  3. #3
    Frank2306 is offline Novice
    Windows 8 Access 2013 32bit
    Join Date
    May 2017
    Posts
    3
    My thoughts exactly, however when I plug some code into the lost focus event of the form, the event doesn't fire.

  4. #4
    aytee111 is offline Competent At Times
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    No, it doesn't. You will need the BeforeUpdate event.

  5. #5
    Frank2306 is offline Novice
    Windows 8 Access 2013 32bit
    Join Date
    May 2017
    Posts
    3
    Worked like a charm. Thank you sir! (thought I tried that event already...)

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Combo box On Dbl-Click event not firing
    By GraeagleBill in forum Forms
    Replies: 5
    Last Post: 12-26-2016, 06:45 PM
  2. Key Down event not firing
    By GraeagleBill in forum Programming
    Replies: 4
    Last Post: 11-18-2016, 12:45 AM
  3. Replies: 3
    Last Post: 09-28-2016, 07:36 AM
  4. Replies: 2
    Last Post: 03-26-2014, 07:30 AM
  5. Form level mouseup event not firing
    By Philhoop in forum Forms
    Replies: 3
    Last Post: 07-22-2010, 09:41 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums