Interrupted Inputs!

• • Reply

  11 years ago

  by prabha_friend

  Karan Prabha

  Mumbai, India

  Joined 12 years ago
  Hello Friends. I am Prabha Karan from Thanjavur (South India). I am currently working in a Retail Management Tool using Ms-Access. I made a menu command which on-action runs a procedure which asks the user to enter the number of the invoice (invoice_no) to open. I used an input-box to get the data from the user. There is no problem in open the corresponding invoice using the docmd command object. But the problem is if the user changes the mind to not open an old invoice, He has to click the cancel button to get rid of the displayed box. But I am getting an error while my user clicks the cancel button in that particular input box. Why? I am giving here the code… Kindly, explain why this is not happening in this way? If possible, tell me an alternate. Thanks in Advance. Public Function open_invoice() Docmd.openform “invoice”,acnormal,,invoice_no=inputbox(“Enter the invoice no and press Ok”) End function
  Report abuse