Opening data entry form with new ID already filled in

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
Back
Top