So I created a cbo box on the form and assigned two Value list column as row source. Now I wanted to auto populate textbox based on the user selection of cbo box. i.e. if 1 is selected by user then txtbox will display One. I don't want user to click anywhere else of loose focus from the combo box so if they want to keep changing, it should reflect the changes in textbox. I tried various methods to achieve this,
1. set Event to "On Change" for cbobox and entered below code
Code:
Private Sub CboStatus_Change()Me.txtPoints = Me.CboStatus.Column(2)
End Sub
This doesn't work at all.