title: Access 2013 Increment a text ID field in a form
body: <p>I have created a database from an excel file, one of the columns (PK) is the license number however this is in text format XX/XX/XXXX </p>
  
  <p>When a new record is created I would like the form to auto-populate the license number field with a similar ID containing both text and numbers. This has to be incremented with every new record (only the number part)</p>
  
  <p>This is exactly what I want to achive however I am getting the error shown below; <a href="https://www.youtube.com/watch?v=kPz-n5w5YtE" rel="nofollow noreferrer">https://www.youtube.com/watch?v=kPz-n5w5YtE</a> </p>
  
  <p><a href="https://i.stack.imgur.com/T5B2J.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/T5B2J.png" alt="enter image description here"></a>
  <a href="https://i.stack.imgur.com/nwqBe.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/nwqBe.png" alt="enter image description here"></a></p>
  
  <p>Any help would be appreciated, I have experience with VB however I am familiar with other programming languages. </p>