Adding one digit to new record in form

[matey56]

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

[moke123]

Use an AutoNumber or DMax()

[matey56]

Use an AutoNumber or DMax()

Can you please help me with the syntax?

[moke123]

Autonumber is a datatype in your table. It auto increments a number.

the syntax for dmax is- DMax ( expression, domain, [criteria] )

https://www.techonthenet.com/access/...omain/dmax.php

[Welshgasman]

Can you please help me with the syntax?

My first point of call is Google?

[matey56]

Autonumber is a datatype in your table. It auto increments a number.

the syntax for dmax is- DMax ( expression, domain, [criteria] )

https://www.techonthenet.com/access/...omain/dmax.php

Unfortunately the table is in SQL Server and not Access.

[Welshgasman]

Unfortunately the table is in SQL Server and not Access.

Never used it from Access, but if the tables are linked to the be sql server, why would it not work?

[matey56]

Never used it from Access, but if the tables are linked to the be sql server, why would it not work?

I'm not saying it won't work. I'm just hopeless when it comes to VB script. If the field name is Auto_Increment and the table is Table1, what is the code I need to enter on the click event to have it add 1 digit to each new record?

[moke123]

https://chartio.com/resources/tutorials/how-to-define-an-auto-increment-primary-key-in-sql-server/