insert an order number when another sheet opens

[Carmen]

I have a form and every time I open it I need it to create a new number. Is
this possible. also if I put it a number that does not correspond to an
other number can it give me a warning.

Thank you so much for your help

Carmen [email protected]