• Tab Form Question? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)

    Home » Forums » AskWoody support » Productivity software by function » MS Access and database help » Tab Form Question? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)

    • This topic has 6 replies, 2 voices, and was last updated 17 years ago.
    Author
    Topic
    #450058

    I have a form with 2 tabs.

    Tab 1 (TabCtl0 0) is the main form and Tab 2 (TabCtl0 1) is a subfrom.

    If I am entering data into the form on Tab 2 and I click Tab1, is there an event I can use to test and enforce that a particular Tab 2 field is entered before switching to Tab 1?

    Thanks, John

    Viewing 0 reply threads
    Author
    Replies
    • #1104958

      The Before Update event of the subform should occur when you (try to) click out of the subform, you can use this to test and to cancel the update if necessary.

      • #1105022

        That works great!

        Thanks, John

      • #1105037

        That didn’t get it, strSalutation is the first control in the tab order, strSalutation is on 1st tab of a Tab form.

        Does frmMembers properties for Popup = Yes

        Any other thoughts?

        Thanks, John

        • #1105045

          Wasn’t that intended as a reply to post 705,321?

          Has the Modal property of frmMembers been set to Yes?

          • #1105053

            I set Modal = Yes, all is OK

            Sorry for the wrong post, can you move this to the correct issue or is something I should try to do?

            Thanks, John

            • #1105066

              Moving posts to another thread is a bit tricky, so let’s leave it at this.

    Viewing 0 reply threads
    Reply To: Tab Form Question? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: