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.