>>>>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

If the table only had a few enties this would be a fine solution, however there are too many entries in the table to list each value in a separate CASE command (it defeats the purpose of having it do a lookup since I could just tell it CASE column1 = "BURG"; column2.text1 = "Burglary". I need a way to have the value of coulumn1.combobox1 examined and the enter a value in column2.text1 based on the values in a row of the table in which both values are associated. I'm sure this can be done I am just stuck today and can't think how to do this.