I have a command button name "New Issue" on a form. When I click on that command button, I get a clean form to enter new data. Within that form, there is a field named Issue Number. I would like to assign that field an automatic fill-in number (i.e. last issue number is 35..would like 36 to be the next number and so on) when the "new issue" button is clicked. The form is populating a table. I can't change the issue number field to an autonumber data type because there is already a primary key and have been attached as a relationship to other queries and tables.
Do you have a code to share to populate and auto number?
Do you have a code to share to populate and auto number?