News, tips, advice, support for Windows, Office, PCs & more. Tech help. No bull. We're community supported by donations from our Plus Members, and proud of it
Home icon Home icon Home icon Email icon RSS icon
  • Subforms on tabs go blank when lost focus

    Posted on Weyrman Comment on the AskWoody Lounge

    Home Forums AskWoody support Productivity software by function MS Access and database help Subforms on tabs go blank when lost focus

    Viewing 0 reply threads
    • Author
      • #2138118 Reply
        AskWoody Lounger

        I have a form that was made by my offsider who is no longer working for us (and neither of us are professional coders).

        In order to speed up display, he unlinked the subforms and the linked the ones on each tab as the tab was selected.

        Tab Change calls a function called form toggle which has code like the following:

        If TabOptions.Value = 5 Then
        If sbfQBOrderInfo.SourceObject = “” Then
        sbfQBOrderInfo.SourceObject = “sbfQBOrderInfo1”
        sbfQBOrderInfo.LinkChildFields = “[Job]”
        sbfQBOrderInfo.LinkMasterFields = “[Job #]”
        End If

        ElseIf TabOptions.Value <> 5 Then
        If blUnlink = True Then
        If sbfQBOrderInfo.SourceObject <> “” Then
        sbfQBOrderInfo.LinkChildFields = “”
        sbfQBOrderInfo.LinkMasterFields = “”
        sbfQBOrderInfo.SourceObject = “”
        End If
        End If
        End If

        With the form open, if you click on another access form, the subform on the current tab goes blank as if it has been unlinked in a lost focus event but I can’t find such a thing.

        Anyone have any ideas as to what is actually happening?

        <ul id=”iw-contextMenu9449″ class=”iw-contextMenu iw-created iw-cm-menu”>
        <li class=”iw-has-submenu iw-mTrigger” title=””>Add to Phrasebook

        <ul id=”iw-contextMenu1234″ class=”iw-contextMenu iw-created iw-cm-menu”>
        <li class=”iw-mDisable” title=””>No word lists for English -> English…

        <li class=”t-1″ title=””>Create a new word list…

        <li class=”t-1″ title=””>Copy

    Viewing 0 reply threads

    Please follow the -Lounge Rules- no personal attacks, no swearing, and politics/religion are relegated to the Rants forum.

    Reply To: Subforms on tabs go blank when lost focus

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