>I have a combo box in a grid that I requery on the after/row column change of the grid to populate with values that are appropriate for the selected record. I want to allow the user to either type in the combo box and save their entry, or they can pick from the list in the combo box to fill in the data. I can get the data requeried but when the data that is typed or selected from the list never gets entered or saved. The grid was working fine saving the data without the combo box but now it's as if the data is not bound even though the control source is set.
>
>Go to the tools and utilities page of my website and download the code samples and white paper from my "Effective Techniques for Using a Combo in a Grid" session. The sample code includea a combo class and a sample form that does this.

Thanks for the help! I've looked over the material and your great word document. I've also tried to use some of the classes but I'm still having a problem.

My issue is that I don't need to bind the combo box values to the control source. I simply want to use the combo box to present a list of possible text to fill in for the user so they don't have to type the string. Basically I have a list of descriptions that can describe a particular option. This description can vary by model so when editing the description I want a combo box that the user can click on to show all the other descriptions for the other models that have the same option. That way if the description is the same the user can just pick it from the combo box. If the description is not in the list, then they can type the description in. But it's not really a bound field I want from the combo box, just a list of descriptions.

I've tried playing with a lot of different properties but I just can't seem to hit on the right combination. The combo box is properly populated with the descriptions. When I pull down the combo box it fills the text into the field, but as soon as I tab off then the data goes away. Any ideas?

Thanks for all your help!


Greg