Please Help Me about My Code

[ionline]

I want to populate my text box on the form with the help of combo box.For this purpose i use the following code.

Private Sub cmbx_AfterUpdate()
Me.txtFirstName.Value=Me.cmbx.Column(1)


Me.txtLastName.Value=Me.cmbx.column(2)
End Sub

The code work well when i try it for the first time.but when i close the form and reopen it,the combo box is fail to populate the text box on the form and the text box remain blank.I try break point also,delet all the old files and make new files but my problem is as it is.
Please let me know by any experience person that how to solve my problem .
Thanks

[June7]

Do you want to save these values to fields in table? Why? Are the textboxes bound to fields?

If you don't need to save the values, just display them, VBA is not needed. Textbox ControlSource property can reference the combobox:

=[cmbx].[Column](1)

Your combobox is named cmbx? Not a very informative name.

Column index begins with 0 so that means column 1 is index 0.

[RuralGuy]

Is the ComboBox bound (does it have a ControlSource)? You only get an AfterUpdate event when the value changes, but you knew that right?

[ionline]

Is the ComboBox bound (does it have a ControlSource)? You only get an AfterUpdate event when the value changes, but you knew that right?

No the combo box is not bound.It Takes values from another source table.

[ionline]

Do you want to save these values to fields in table? Why? Are the textboxes bound to fields?

If you don't need to save the values, just display them, VBA is not needed. Textbox ControlSource property can reference the combobox:

=[cmbx].[Column](1)

Your combobox is named cmbx? Not a very informative name.

Column index begins with 0 so that means column 1 is index 0.

No i required to save the value so i need to be use VBA.My VBA code work only for the first time .When i close and reopen the form .then the code did not work.

[June7]

Your code saves data to record. As RuralGuy pointed out, the code only executes when the combobox value is changed.

If you want the saved values to display from record, then set textbox ControlSource property to field.