How to update a record through a form

[tankertert]

Im new to access and im having trouble implementing something. Basically, i have a form with a combo box, some text boxes, and a command button.

What i want to do is have the user select a record from the combo box, which then populates the textboxes (I've already managed to do this). Once the data has loaded into the textboxes, I want the user to be able to edit the info in the textboxes, then press the command button so that it updates that record in the table.

Any ideas?

Thanks

 

[Alansidman]

If your form is bound to your table, there is no need to have a command button to update the table. Move to the next record and the table will update automatically.

 

[tankertert]

The problem is, is that it does change the necessary details, but saves both copies. The before the change copy of the record, and then also the after the change copy of the record.

 

[Alansidman]

mmm. Sounds like it is creating two records. One after the dropdown selection is made and then again after the edits. Do you have any code behind the form? If so, it would be helpful to see what is happening. Perhaps post a sampling of your db so that we can see the whole instance of events and evaluate it. Otherwise, we are pretty much guessing at what you have going on.