Using access 2013
I have a report that i use to populate change orders for my job. I created a button to take me to this form when i have to populate a new change order. I number them S1, S2, S3,,,etc,,etc,,,,how can I make the box where the number goes be automatic? Meaning when I hit the "Create New Change Order Button"....and the form pops up it will automatically be numbered the next chronological number...beginning with the letter "S". ("S" btw stands for "scaffold".)
I have a report that i use to populate change orders for my job. I created a button to take me to this form when i have to populate a new change order. I number them S1, S2, S3,,,etc,,etc,,,,how can I make the box where the number goes be automatic? Meaning when I hit the "Create New Change Order Button"....and the form pops up it will automatically be numbered the next chronological number...beginning with the letter "S". ("S" btw stands for "scaffold".)
