auto generate an number
I am creating a system by using A2k. I want to assign a document number (sample : A001) to each record that has been added. Is there any way to auto generate a document number in access? which means i do not want the user to key in, the document number will be generated when / after the add button is pressed.