>>>I have a grid displayed on a form. One of the columns in the grid is a combobox which has as a sourse a field in a table. I want another column in the grid to display the contents of another field of the same table based on the entry selected in the combobox column. For example, the combo box displays a four letter code, in the table the code is associated with a specific crime (e.g., BURG is associated with Burglary). When "BURG" is selected in the combobox column how do I get "Burglary" to be displayed(entered) in the textbox column of the grid?
>>>TIA
>>>--lincoln
>>
>>You can reset Column1.Controlsource from Combo.InteractiveChange event.
>
>
>I don't understand what you're telling me. What do I put where?
***Combo.InteractiveChange event
DO CASE
CASE This.Value="BURG"
Thisform.Grid1.Column1.Controlsource="table1.burglary"
CASE ...
...
ENDCASE
Thisform.Grid1.Refresh
Edward Pikman
Independent Consultant