Combo box help...

[Paul Mak]

I have an unbound combo box in a form for user to select/type in a "Full
Name" and use it to filter out records from a table. The control source of
the combo box is based on that table so that I can select a "Full Name" from
the drop list. I also have the "on not in list" event to allow a new "Full
Name" adding to the table. "Full Name" is not a primary field and
duplication is allowed. What I want to achieve is to create a function so
that if two persons with the same "Full Name", user can create a second same
"Full Name". I am thinking about a new button called "New" next to the combo
box, use the "after update" event on the combo box, if the "Full Name" exist
in the drop list of the combo box, the "new" button appears, user have the
choice to tab in to use the existing one or click on that "New" button and
when clicking on the "New" button, it will use the same procedure as the "on
not in list" event. My question is how to tell Access in the "after update"
event the "Full Name" typed in already existing in the drop list and make
that "New" button visible.