In the InteractiveChange of the combobox put the following code for example:
first find the information you want to insert into the grid. I've stored it in there variable to make it easy, then:
replace gridtable.adress with cAdress, gridtable.state with cState, gridtable.zip = cZip
and of cource replace gridtable with your recordsource for the grid.
I don't remember if you have to do a refresh on the grid but I don't think so....
/Mårten Törnquist
>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
---( Mårten Törnquist )---