Re: Need 'entered' value added to list

Tech-Archive recommends: Fix windows errors by optimizing your registry

Use the LimitToList = Yes!

(then you can use the NotInList event to popup a data entry form to add the
new values and repopulate the combobox).

Regards

Jeff Boyce
Microsoft Office/Access MVP


"p-rat" <osupratt@xxxxxxxxx> wrote in message
news:1fe004e2-90a0-4bca-bb38-26d5ea78305d@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I have a combo box that when a value is selected from the list (query)
it autofills an unbound text box with another value in the same row of
the query return. The combo box has for example Employee Names and the
unbound text bound will show the Employee ID Number.

I have the combo box set to 'limit to list'=No. The data entry clerk
can add a value that is not on the list and that is fine. How do I
have the unbound text box require the clerk to enter in the Employee
ID Number and how do I get these two values (newly entered Employee
Name and newly entered Employee ID Number) to be added to the query/
table list in the back so the next time the clerk goes into the form
the before mentioned Name/ID Number will be in the drop down?

Thanks for any help.


.