refresh fields in subform based on combo box

[joyaccess1]

Hi,

I have a combo box in the subform, when i select the value in the combo box i need all other fields in the subform to be refresh with the data, i tried requery and refresh, both don't work, the data in the other fields in the subform doesn't get refresh.

is there something that i am missing ?, any help will be apppreciated.

Thanks
Joy

 

[boblarson]

How are the other fields populated? It sounds like you might need to have all of the field data in the combo box's rowsource and then in the After Update event of the combo you use VBA to set the values:

Me.YourField1 = Me.ComboName
Me.YourField2 = Me.ComboName.Column(1)
Me.YourField3 = Me.ComboName.Column(2)

etc.