I need to find out how to allow a user to add an item to a drop down list that does not already exist in the drop down list. I am not sure If i need to write a macro to do this or if there is a setting that can be used. For instance. A user is entering data in the database. The come to a field in the form that has a drop down list of categories including "staff", "trainees", and "agencies". The information they are entering needs to to go into the category "vendors". I have the field set to No for limit to list, but how do I get the data they enter to automatically add to the list? Thanks.