When I edit a record in a form it duplicates instead of updateing. How can I stop thi

[SJB67]

Hi,



I have a simple table of customer contact details with a form to view/edit them.

When I edit a record (e.g. I change the company name) it creates a duplicate record with the amendment.

My primary key is a customer number which I am not changing.

I have searched but can not find any reference to anyone else having this problem.

Can anyone suggest areas where I could try to rectify?

Thanks

SJB

[ItsMe]

Use a bound form as a graphical interface. With the form open in Single Form View or Datasheet View, navigate to an existing record to edit said row. To append a record, navigate past the last row or use the intrinsic New Record button.

[SJB67]

Many thanks - but that is what I have done.

As I say it then records any edited record as a new record.

Creating a new record is not a problem.

[ItsMe]

Suggest creating new DB file. Import one of the tables that your form is based on. In the new DB, create a new form. In your new DB try to edit data. If successful, add more tables and or queries until you have a new DB with the components necessary to replicate your original form that is causing issues.

[Xipooo]

I believe you have forgotten to include the primary key as a field on your form. Add a textbox and bind the key of your table to that textbox. Then make the textbox hidden so your users won't see it.

[Missinglinq]

Not having the Primary Key on the Form wouldn't cause this kind of thing. My guess, which I believe is shared by ItsMe, going by his suggestion of importing objects, one-by-one, into a new file, is that corruption has reared its ugly head, most likely in the Form in question.

Linq ;0)>

[SJB67]

Many thanks both. I have identified the cause but have as yet no solution!

Everything works until I make the ID box a combo - so I can drop down and choose which client. I can now see the logic in this as my other fields are then working on the ME.txtbox.Value=Me.Combobox.column(3) etc, and obviously I am then changing a column so it has to save as a new record.

Does anyone know the best way to be able to search and select a record from a field within the form which won't cause this problem?

Eventually I was planning on using 'strings' from what I have read....

Thanks for all the help.

SJB

[Missinglinq]

Sorry, but why didn't you tell us this in the beginning? I think you've made a common mistake. Your Combobox is Bound to the ID field, and in order to use a Combobox to retrieve Records it has to be Unbound! You need to go back to a separate Textbox to hold the ID field for each Record.

Right-click the Combobox, click on Properties then on the Data Tab see if there's something in the Control Source. If there is, delete it, add a Textbox and Bind it to the ID field.

Linq ;0)>

[SJB67]

many thanks I got it working

[Missinglinq]

Glad we could help!

Linq ;0)>