DataCombo Box Refresh

[judyscofield]

Two things. I need to fill other fields in a tablewith values from a table used in a datacombo box besides the bound field. How to I move to the selected record in the datacombo source table to capture those other fields and move the values into my main table.

Also, the other fields displayed on the form don't refresh until I move to another control. How do I force the lostfocus event of the datacombo. I tried to set the focus to a different control in the Change event of the combo box, but I receive an error.

Thanks