Hi,
i have a form with a text field.

When the user enters data in it, i use the Exit-Event to check the data and
want to
open another form AND close the current, something like that:

Private Sub textIDBerater_Exit(Cancel As Integer)
    DoCmd.OpenForm frmEmpfang_Men
    DoCmd.Close acForm, frmEmpfang_MieterNeuerTermin
End Sub

BUT, the DoCmd.Close gets an error: Not allowed while in an event?

So, how to step from one form to another when leaving a text field?

Thanks
Ralph

Ralph G?stenmeier ICQ#:105344449

There may be more elegant solutions but one way is to use the Form_Open
Event of the second form to close the first Form with a DoCmd.Close.

--
HTH
Van T. Dinh
MVP (Access)