Community discussion forum

Interrupted Inputs!

  • 8 months 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
    Post was edited on 22/03/2009 22:59:35 Report abuse

Post a reply

No one has replied yet! Why not be the first?

Sign in or Join us (it's free).

Want to stay in touch with what's going on? Follow us on twitter!