combox box with update new value

[Guest]

I have a combo box to display a list of name. I need to deal with the case
that when a user enter a new value of name then it would pop up a message
asking for add new value. If the user say, "yes" then that value is entered
into the list and also into the table.
Can you show me how to do that?
Thanks

 

[Fred Boer]

Dear Tim:

There is code at the following link which demonstrates how to use the
"NotInList" event to accomplish what you need:

http://www.mvps.org/access/forms/frm0015.htm

A couple of points, however:

1. This code is set up to add a single value to a field. Are you storing
"name" as a single field, or in multiple fields (i.e. FirstName, MidName,
LastName)? If so, you would need to modify the code to deal with this...
2. Another option to deal with this is to pop up a data entry/edit form when
the user needs to add a new value.

Good luck!
Fred Boer

 

[Guest]

Wow!! thank you for your information. Look like everything is clear. I
appreciate that.

Tim