Hello!
Sorry for my poor english, I'm using goole translate to write this post.
I have problems to get focus back on a form.
I have one form "MyForm" and one control "MyControl"
On_exit on "MyControl" I run:
Code:
"Sub Makeback_up ()
Dim SokUsb As String
SokUsb = "g: \"
DoCmd.OutputTo acOutputQuery, "qryBackUp" acFormatXLSX, SokUsb & "back_up" & Date & ". Xlsx"
End Sub
.
The docmd.outputTo makes the form to deaktivete.
(the event MyForm.deactivate is raise).
I can not programaticly get the focus back to the form by Using "MyForm.setFocus" or any other way I tried.
All help is appreciated.
Thank you!!