Access 2000 Form - save record, clear KEY field but leave all other fields as they are.

Question

A Database and entry form created by a dead relative in 2003 is giving me trouble. I would like to change the FORM to save the record data entered - clear the KEY field and leave the other data fields loaded.
The wish iis defeating me at the moment. I have some IT experience but it is 29 years old!

Answer 1

Duane is absolutely right. The reason behind a request like this, which falls outside normal practices, requires clarification, not blind fulfillment.

There may be a justifiable reason for doing what is described. Please explain that reason.

Thank you for helping us help you.

Answer 2

You should provide the reason why you want the key field empty and the other controls populated? Are you attempting to create duplicate or near identical records? Do you want to set default values for new records based on the last entered record?

Answer 3

Dear @DAVID DE-LA-COUR,

I would be glad to help you resolve this issue with your Microsoft Access 2000 form! To ensure I provide you with the exact and safest solution for your specific database setup, could you please help me narrow down a few details first?

1. What data type is the KEY field? (For example: is it set to AutoNumber, Text, or Number in the underlying table design?)
2. Is this KEY field designated as the Primary Key of the table?
3. How do you currently navigate or save entries? (For example: using the built-in Access navigation bar at the bottom of the form, or custom command buttons on the layout?)
4. Are you encountering any specific error messages when trying to save or clear fields?

Once I have these details, I will provide you with the exact code and step-by-step instructions tailored directly to your form. I look forward to your reply.