Hi all!
I'm using a continuous form to generate drawing numbers for steel fabrications. Each number is simply incremented by 1 every time but is prefixed with the page format size (A1, A2, A3...).
I have the combo box pulling the format size from tbl_Format and then using a text box to combine the combo box selection with the Drawing_ID auto number.Code:=[Format_Size] & "" & [Drawing_ID]
This is all working fine, except for when you want to abort the input by pressing esc as the form disregards the number created initially, then skips to the next number. Also, if the format size is changed then the number will not update the prefix in the text box.
Please could someone point me in the right direction to stop this happening!
Many thanks!