Find Maximum Value of a Field and Add 1

[jhillbrown]

When I create a new record in a form, I need the ID field on the form to automatically be the highest number found in the ID field plus 1. The table name is tblContacts. Is there a formula for this and where do I put it? Autonumber is not an option. Thanks!!

[pbaldy]

You can use the DMax() function to find the largest value, and add 1 to the result. It would be done in code, at whatever point is appropriate to your application.

[ConneXionLost]

Just fixing the typo:

DMaz() function

should be:

DMax() function

Cheers,

[pbaldy]

Thanks, I've corrected the post.