Input Message Box

[IanT]

I am using Input Message Box to obtain filter data. Is it possible to catch when someone uses the cancel button on the input box. If cancel is used I would like to responed with code a message box for example!

 

[Bat17]

cancel will return an empty string same as if the leave it blank and click OK so just test for ""

HTH

Peter

 

[DB7]

Yes Peter is correct, mind you, in case this is relavent, pressing Ok, with no response will also return "". So to differentiate, more precisely...

If vbCancel = InputBox("Pick Number From ....",vbOkCancel) Then
....

or

Dim varResponse As Variant

varResponse = InputBox "Pick Number From ....",vbOkCancel

Select case varResponse
Case vbCancel
MgBox "You Must Reply by...
Case vbOk
Docmd.Open....
End SElect