Hello,
I currently have a form where I'd like the default value for one of the textboxes to be the maximum value in a field + 1. Basically, I want my primary key field to increase by 1 each time a record is inputted, just like the autonumber field would do. All I need is the vb code to put in. I've already got about 1200 records in the database so i think its it's too late to use the autonumber field. Any help would be greatly appreciated. Thanks alot. Access 07 by the way.
I currently have a form where I'd like the default value for one of the textboxes to be the maximum value in a field + 1. Basically, I want my primary key field to increase by 1 each time a record is inputted, just like the autonumber field would do. All I need is the vb code to put in. I've already got about 1200 records in the database so i think its it's too late to use the autonumber field. Any help would be greatly appreciated. Thanks alot. Access 07 by the way.