Opening data entry form with new ID already filled in

[Guest]

I would like to open my data entry form with the next (consecutive,
non-duplicate) ID already filled in (rather than having the user come up with
a number and find out at the very end that this number/ID has already been
taken).

The control is bound to a field that is indexed and doesn't allow for
duplicates.

How can this be accomplished?

Or is there a way to change the generic Access error message that says that
there are duplicate keys, which doesn't mean much to the average user?

Thanks.

 

[Guest]

Check this link on "Automatically Increment a Fields Value in a database"

http://www.databasedev.co.uk/automatically_increment_value.html