Originally Posted by
bcmarshall
This is a simple issue to resolve. Use a SetValue command within a macro, and set the value of the desired field to DMax("[FieldName]","[QueryorTableName]")+1. It'll act like an autonumber field, always incrementing the largest number available by one. Since it is not an autonumber field, should you choose to manually insert another number it will allow it. Make sure that the properties in the table are set to Indexed: Yes (No Duplicates). That will prevent you from accidentally entering the same number twice.