Auto fill text box

[edgarchado]

Hi,

I am using a combo box which, after selecting an option automatically
fills a text box. In my case, I choose our clients name from the combo box
and it should automatically fill his telephone number in the text box.

The problem is the it does not fill it automatically. I have to click on
the text box and press enter so it can retrive the value.

I am using this code in the afterupdate event of the combo box.

Private Sub Productora_AfterUpdate()
Me.ID_Productora = Me.Productora.Column(2)
Me.Telefono_Productora = Me.Productora.Column(1)
End Sub

Any idea of what it could be happening???

Thanks in advance.

 

[edgarchado]

Sorry, wrong forum.. will post in forms forum.

 

[JoeEskimo]

Try using the ON CHANGE instead of AFTER UPDATE