Update Command Button

[tranzit]

i currently have a form which consitis of a combo box and a text box. When a selection is made in the combo box corresponding data from the table is displayed in the text box. i am wanting to set it up so that if the data in the text box is changed the data in the table is also changed.

How do i go about doing this?????

Any help would be great cheers

[missinglinq]

Place a button on your form and behind it put this code:

Private Sub SaveRecordButto n_Click()
docmd.RunComman d acCmdSaveRecord
Me.Requiry
End Sub

Good Luck!

[tranzit]

I added the button but it didint update the table with the changes made on the form....