Open form when value isn't appropriate the input mask!!

[Fekri]

Hi,

I made an input mask on one of my text box in form.

and I need to open a specific form when the value in that text box isn't appropriate the input mask specified.

Thanks for any advise.

Ali

Thanks & Good Luck
Ali Fekri

 

[TheAceMan1]

How are ya Fekri . . .

[ol][li]In the code module of the form, copy/paste the following routine ([blue]you![/blue] substitute proper names/values in [purple]purple[/purple]):

[blue]Private Sub Form_Error(DataErr As Integer, Response As Integer)
    
   If DataErr = 2279 Then
      MsgBox "[purple][b]Your Message Here![/b][/purple]"
      Me("[purple][b]YourTextboxName[/b][/purple]") = Null
      DoCmd.OpenForm "[purple][b]FormName[/b][/purple]"
   End If
   
End Sub[/blue]

[/li]
[li]Perform your testing! . . .[/li][/ol]
[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]