Main form CustID format is XXX-XXXX-X-X (ex: 123-4567-8-9)
Now in my subform i have OrderId which i want to be same format as CustID. Only diff it would is the last digit in Order ID. So for example if CustID is 111-1111-1-0 then OrderID would be 111-1111-1-1 next OrderID should be 111-1111-1-2. Is it possible in Access that i can do something so that the User don't have to type in the whole CustID in OrderId field.
I would somehow like my user to only enter the last digit of OrderID since all the other digit will be same as CustID. How can i do this ?