Updating existing records using forms

[Sean]

I am having problems updating records using my forms. I will have multiple people using the database and I did not want them to accidentally delete parts of records, so as a precaution I wanted them to be able to type in a job number (job number is my primary key in my tables) and have the record for that number come up in the form so that they can make corrections to the data. I wanted them to be able to see ONLY this one record. Unfortunately, if I do this, (I've tried using Data Entry mode) it always tries to create a new record with the data and that creates duplicate primary keys and so I get an error message.
Does anyone know a way to pull up a single existing record at a time in a form so that it can be edited?

Thanks, Sean

 

[Sean]

Thank you very much, that helped a lot.