Closing first form after update

damutech

New member
Local time
Today, 21:41
Joined
Mar 8, 2006
Messages
2
I have a control in Form1 and after LostFocus it open a Form2, Form1 rests still open. But I want to close Form1 after LostFocus. How can I do that?

Here is an example:
Form1:
Private Sub POD_LostFocus()
Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "Form2"
DoCmd.OpenForm stDocName, , , stLinkCriteria

End Sub


Thanks!
 
What you could do is create a macro that first opens form 2, and then closes form 1.
Only catch is that this doesn't seem to work On Lost Focus. If attached to a command button, however, it functions beautifully.
 

Users who are viewing this thread

Back
Top Bottom