Combo Box help

[bdjb]

Hello,
Using MS Access 2003, I have a combo box with 4 columns. Three text boxes are set to update on the choice from the combobox (using =Course.column(3) etc). Is there any way to make those 3 text boxes changeable by the user? Right now it will only allow the combobox value.

Thanks!

 

[Remou]

Instead of setting the control source to =Course.column(3) etc, use the after update event of the combobox to update the textbox via code, however, you could get into difficulties with saving and synch-ing, depending on your set-up.

 

[bdjb]

Thanks Remou,
I'll give that a try.