Hi Lincoln,

This may be a bit presumptious on my part, but are you just wanting to show the description of the code? If so, you could do it all in the same combobox. Set your control source to the code field (burg) if you're saving this data to another table, if not, leave it blank. Then set the bound column to 2, make the total columns 1 and in your select statement (if that's what you're using for the record source), be sure to select the description first and the code second. This way, the user looks up by the code, chooses it, then the description is what shows on the grid... Just a thought.


>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