I have a combo box in a grid. What I would like to do is when someone chooses something in the combo box, I want the next 3 fields in the grid to be automatically be filled with the information which pertains to that record. For example, if someone picks someone's name in the combo box. I want the next 3 fields to automatically fill in the grid with other information, like the person's street address, state, and zip. How do I do this?

TIA,
Jim