Updating a table from unbound textboxes

[magster06]

Hello all,

When a user selects a name from a combo box then 11 textboxes are populated with personal information.

What I am looking for is when the user edits the persons information (i.e. changes the persons phone number to a different number), how do I update the table with this information?

Is there a way to only update fields that have changed? or do I have to save all textboxes?

I have read about an "Update Query" and a SQL Update, but I did not think the two applied. I am sure that I am wrong, lol.

I tried the "Docmd.Runcommand acCmdSave (in the OnClick event cmd button) but it did not make any changes to the table.

This is what I put in the OnClick event:

Private Sub cmdSaveEdit_Click()
    DoCmd.RunCommand acCmdSave
    TextBoxLockDown
    Me.Requery
End Sub

Any help would be appreciated!

Sorry if this has been addressed somewhere, but I could not find exactly what I was looking for or maybe because I am so tired I could not see the answer which was probably in front of my nose this whole time.

 

[magster06]

Uncle Gizmo,

Thank for your response and suggestions. I think I am going to try your first suggestion as I would like to keep my original form design.

Thanks again for explaining about the combo box.