Using the Cancel on an InputBox

[Henley12]

How can I program to use the Cancel on the InputBox? I have a form that has a copy button on it. When I copy the record, it prompts for a new Equipment number. If the number exists, a msgbox pops up telling the user to enter another equip number. It then goes back to the InputBox to enter an equipment number. If you hit the cancel button, it just keeps going back to the msgbox telling the user the number already exists. Can you program in VBA to completely cancel the operation if the cancel button is pressed on an InputBox?

 

[pbaldy]

Try testing for a zero length string ("").