I am lost on this. I need to add what is added in an InputBox to a textbox on a form and to a field in a database. I want to have OK and Cancel. How can I check for Cancel and get the value?
Code:
Dim iResponse As Integer
iResponse = InputBox "Add Note"
If iResponse = 1 Then 'user hit Ok
      'this will check for the cancel but how do I get 
      'the data entered
Dim strNote As String
strNote = InputBox("Enter Note for"  & ListView1.SelectedItem, "Add Note")
     'this get the data but not the Cancel
     'How do I do this?