Hi Marcia

Typically a combo is used for displaying a set of valid choices from some sort of lookup table from which the user can select. This value is then used to populatye a field in another table to which the control is bound (i.e., its ControlSource).

Perhaps you have chosen the wrong control for the job here. What is it that you are trying to accomplish?


A form in which the user can search in the database but also
can add a new user. When opening the form all fields have a value also
the combo box. When using the Add command all fields must be empty

Ben