Input box cancel question..

[jmorlock]

I have the following input box in my form prompting for a name. If the user presses the cancel button how to i catch that? I want to close the form once he clicks the cancel button.

prompt = "Please enter the Client Name."
name = InputBox(prompt, "Survey", "Enter name here.&quot

 

[nat1967]

hi,

try this:

'**********begin code example********

Dim prompt As String
Dim Name As String

prompt = "Please enter the Client Name."
Name = InputBox(prompt, "Survey", "Enter name here.&quot
If Name = Empty Then
DoCmd.Close acForm, Me.Name
End If

'***********end code example************

HTH

Have A Great Day!!!,

Nathan
Senior Test Lead

 

[train2]

I've not tested it in detail, but isn't it just blank or null? You could test it out by displaying a msgbox with the value of name just to see it displayed.

Let me know how you get on.
jr

 

[jmorlock]

Yeah if you hit the cancel button the inputbox will return either "" or null value. Thanks for the help