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

    This topic contains 0 replies, has 1 voice, and was last updated by  Weyrman 1 week ago.

    • 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

    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.