Anyone seen this before?
Symptom:
Win10 64-bit Access 2016 DeskTop application and caller form LOSES FOCUS after (opening and closing a Modal Dialog form).
When Occurs:
Upon closing the Modal Dialog, Focus switches from the Access Application to the Win10 File-Explorer or Calculator (whatever happens to be open in windows at the time) as if Alt-Tab was used to switch windows.
Details:
The Modal Dialog performs data entry and a DAO back-End table update before being closed by user action (Button) and attempting to return to the calling form.
Dialog Call and return logic is in a form sub procedure:
DoCmd.OpenForm FormName:="frmItemSaleDetMain", _
WindowMode:=acDialog, _
WhereCondition:=BuildCriteria
(Field:=strField, FieldType:=dbText,
Expression:="TempVars!CurrentSaleDetID"), _
OpenArgs:=ItemDescription & "," & ItemDescription2
'MsgBox "Returned "
Me!QtyShipped = Nz(TempVars!CurrentQtyShipped, 0)
DoCmd.GoToControl "QtyShipped"
Me!QtyShipped.SetFocus
Control is returned from the dialog via :
DoCmd.Close ObjectType:=acForm, ObjectName:=Me.Name
Help!
Is this caused by some kind of database table contention?