Hi all,
I have a table where the Record_ID is the key field. I want to program that field in my form to add one digit to the highest record ID in the table every time a new record is added. Currently my Add Record button has the code below. How do I code this?
Private Sub cmd_add_record_Click()
Me.AllowAdditions = True
DoCmd.GoToRecord , , acNewRec
End Sub