Saving data to a table.

[19thJIS]

Greetings all,

I am trying to setup a command button that allows a user to use a combo box to populate four unbound text boxes. The code for this is:

Private Sub cboNameList_AfterUpdate()

Me!cboNameList.Enabled = True
Me!txtAttorney_Number = Me!cboNameList.Column(0)
Me!txtAttorney_Number.Locked = True
Me!txtLast_Name = Me!cboNameList.Column(1)
Me!txtLast_Name.Locked = True
Me!txtFirst_Name = Me!cboNameList.Column(2)
Me!txtFirst_Name.Locked = True
Me!txtMiddle_Initial = Me!cboNameList.Column(3)
Me!txtMiddle_Initial.Locked = True

End Sub

They also fill in some additional information for a panel they are creating.

When I click the save button, it executes an append query for the table. The problem is that the data is not saved. Any suggestions on what I might be doing wrong.

Thanks