Auto increment field

[ayh1]

I have a table created in sql server linked to my adp project, I have a field course_id I have a form to create new courses when I click the button I get an error saying course_id is null value, how can I program in vba so that the value auto increments when I click new course button.

 

[llkhoutx]

On the BeforeUpdate event determine the maximum ID, increment it and store in your row being saved.