I am a newbie so go easy on me. I want to use the selection made in the combo box to Update a table. Currently the after they select the ID number in the combo box and it then fills in a few text boxes with info about the ID number.
I want to have an update button that can be clicked and it will then update a table, called Prior, where the location equals the ID number selected to a field in one of the text boxes, Me.txtBranchCenterID .
Private Sub cboAtmCenterID_Click()
Me.txtLocationName = Me.cboAtmCenterID.Column(9)
Me.txtServBranch = Me.cboAtmCenterID.Column(3)
Me.txtBranchNumber = Me.cboAtmCenterID.Column(2)
Me.txtBranchCenterID = Me.cboAtmCenterID.Column(14)
End Sub
Thanks for the help.
I want to have an update button that can be clicked and it will then update a table, called Prior, where the location equals the ID number selected to a field in one of the text boxes, Me.txtBranchCenterID .
Private Sub cboAtmCenterID_Click()
Me.txtLocationName = Me.cboAtmCenterID.Column(9)
Me.txtServBranch = Me.cboAtmCenterID.Column(3)
Me.txtBranchNumber = Me.cboAtmCenterID.Column(2)
Me.txtBranchCenterID = Me.cboAtmCenterID.Column(14)
End Sub
Thanks for the help.