Close a form based on input value 1

[carwil]

Can a form be closed based on an input value in a text box?

For example, if it a date is entered that is >=date() then display a message for a specific length of time (6 sec) then close the form.

Thanks!

 

[MajP]

You can not make a standard msgbox close after a given period of time, but here is some code for a good work around. You can build your own form, but this provides a lot of flexibility.

http://www.mvps.org/access/forms/frm0046.htm

Private Sub txtBxCloseOnValue_AfterUpdate()
  If Me.txtBxCloseOnValue = "Close" Then
    MsgBox "You entered 'Close'. About to Close", vbinfo, "CLOSING"
    DoCmd.Close acForm, Me.Name
  End If
End Sub

If you desire replace the Msgbox with a call to the code from the link above. Then you can use set the display time.

 

[carwil]

MajP,
Thank you so much. This is exactly what I was looking for. I also appreciate the link. Another good source of information.

Have a great day!