I have a table (Cons) where I record all the transaction and which I fill with data through a form. First column of the table is a ID column and is primary key. I have set it's data type as integer and not as an autonumber in order to save some megabytes in the database size. In the form Cons_ID is the text box from which field value is saved to the table's ID field which is also named Cons_ID. I need to put some kind of event procedure in the form which by default saves an incremented number which is greater by one from the maximum value in the ID field before the form's data is saved to the table.
I have attached a sample.
G.zip