Hi all,

I have a Access DB and the key field is a code like this C####. (e.g. C0001, C0054). The number is meant to match up to the record number, so when they're browsing the form the thing at the bottom says record number 5 and they're on C0005.

Make sense? I hope so I would like to automate this field (at the moment the user just types in the key code, but they keep messing it up). Is there some way I can make a macro or module that knows when a new record is created and automatically puts the correct value in this field?

Any help would be greatly appreciated, thanks heaps for your time.

Ang