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
