I am trying to create a database for actors and filmography.  Atr the rish of typing repeat data... Is there a way if you type into a field and it has the film already in the db, it will populate the field for you...If it is new then it automatically adds the film title to the db table/querry.

---

Reply from Richard Rost:

You could make a combo box that shows a list of all of the titles in your table, pulling just on Title. As you start typing, it should autocomplete and drill down to that title. Set the combo's "LIMIT TO LIST" property to false. If the title is not in there, you would then be able to add it as a new item.