>I have been using Combo Boxes with an SQL row source to populate the Combo Box. The SQL is simply displaying the grouped values from the table for that field. Is there any way to set the combo box so that a person could type in a new value in the combo box field? For example, the field is position, and the list is 'Select position from workers group by position into cursor tposition'. What if there is a position that is not on the list? As I have been thinking about this, I can already think of ways to do this using a value list, or a small position table. I am curious whether my question is possible? Thanks.
>
>Mike
Generally what is done in this scenario is to set the combo box style to 0-Dropdown Combo so the user can type new values in the textbox portion of the combo. Then in the combo's LostFocus ( or possibly Valid ) event you cant test on the combo's Value and DisplayValue properties. If they are not the same, a new value was typed in by the user. You can then run code to take whatever action is necessary, e.g. add the new value into the combo's list using Additem() and/or AddListItem(), insert the new value into a table, etc. Your particular scenario may require variations on the basic theme.
Bill
William A. Caton III
Software Engineer
MAXIMUS
Atlanta, Ga.