access 2010

[awake2424]

Is it possible to have a field (Color) on a form be set to a combo box. A drop-down box appears with Green, Red, Blue, Yellow, Other. When other is selected a dialog box prompt appears asking the user to enter the color. The response is then what appears in the Color field. Thanks.

 

[Beetle]

Yes, if you use a combo box with the Limit To List property set to Yes, then you use the Not In List event to handle adding new values that the user enters. It wouldn't really be necessary to have them select Other first, then enter the new value. They would just enter the new value directly in the combo box. If for some reason you want them to select Other from the combo box first, then it would have to be coded a different way because the Not In List event would not fire.