updating text boxes based on combo box value

[Guest]

Hi ok so heres the deal. I have a form where i use a combo box to select
records. I use a subform to add in a new record but only the name field. upon
return from the subform i set the combo box to the new value so i can edit
the rest of the fields using the line of code:

Form_FrmIP.Combo19 =
Form_FrmIP.Combo19.ItemData(Form_FrmIP.Combo19.ListCount - 1)

anyway the problem is that the text boxes on the form displaying the
information on the record don't update when i do this. so while the combo box
says the newest entry the text boxes still display info on the last record
selected so if i change them they're change the data for that record instead
of the new one. The text boxes are linked with the proper fields in the
tables as control source but i don't know how to get them to update to the
record i want using code instead of my combo box. Any ideas??

 

[Guest]

Well i figured it out i made the afterupdate of the combo box public and then
just called it from the subform.