I've got the following piece of code which selects an input mask based on the customer order type

Select Case Me!CustomerOrderType

Case 1
' Set Order / Survey Number Input Mask based on Order Type
Me!OrderSurveyNumber.InputMask = "E-0000000;0;_"

Case 2
Me!OrderSurveyNumber.InputMask = "P-0000000;0;_"

End Select

The code works fine for case 1, as the number is supplied to us from an outside company. The problem is with case 2 where I need the Order Survey Number to act like an auto number field.

Thanks in advance

Please don't post your questions in more than one Forum. If you can choose one it belongs in, use that. Otherwise General is always a safe bet.
Jack Cowley has already answered your identical posting here: http://www.access-programmers.co.uk/ubb/Forum1/HTML/007252.html
Post a reply in that thread if you need more assistance and someone will hopefully be able to help further.

Good luck,
David R