Modifying existing record from form

[Guest]

My goal is to try to create a form that allow users to search for a record in
the table and pre-populate the information in that record, and then, allow
users to input data into fields that has not yet been filled or to
overwrite/change the existing record information for that particular record,
without adding a new record (to avoid duplicates) but simply change the
information to that record only. I have only gotten the form to add new
records (using bound form) which I don't want, but I am not sure how to go
about just modifying the existing record. Does anyone know?
Many Thanks!

 

[Stuart McCall]

My goal is to try to create a form that allow users to search for a record
in
the table and pre-populate the information in that record, and then, allow
users to input data into fields that has not yet been filled or to
overwrite/change the existing record information for that particular
record,
without adding a new record (to avoid duplicates) but simply change the
information to that record only. I have only gotten the form to add new
records (using bound form) which I don't want, but I am not sure how to go
about just modifying the existing record. Does anyone know?
Many Thanks!

Set the AllowAdditions property of the form to No. That makes it impossible
for the user to add new records.

 

[Guest]

I try setting the AllowAddition Property to No but the form completely
disappeared in form view. I would like the user to search for data, modify it
and be allowed to save the changes made to the same data record. Sorry if it
was not clear what I indicated before. Thanks again!