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

 

[Pat Hartman]

DataEntry mode only allows Adds. It does not allow change or delete.

Use an unbound combobox or text control to enter the Job number. Then filter the form by that control. Set the AllowDeletes and AllowAdditions properts of the form to No.

 

[Sean]

Thank you very much, that helped a lot.