I open a form and it says "(New)" in the primary key field. I need to write code such that the end result is that the primary key field will change to the value of the new record, rather than the form saying "(New)" and I need to do this as early after the form opens as possible. What command/code can I use to do this. To be perfectly clear, at some point, either through data entry to a field or some other change to the form, the form will eventually get a new autonumber primary key, I need to control that process via code, and not rely on user interaction to get a new primary key. Thanks.