I have a combo box on a form. This combo box is repeated 4 times to give the user the option to select 4 different choices. Once the choice is made, I want a text box next to each combo box that displays the description field based on what the user selected. Can someone tell me how to write this simple code.

Thanks

Michele Haywood

__________________
Michele Haywood

The simplest way to do this is to use the combo box wizard to select the PK, the selection field, and the description field, then change the column display to 0";1";0". This will hide the PK and the description field.

On the combo box, after update event (help me guys) put this code:

Me.txtMyTextBox = Me.cboMyComboBox.Columns(2)

See if that works.



mmcdonal

Yes, that sounds correct, MMcDonal. You can also use a DLookUp to populate the textbox, but your way is faster resource-wise.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division