Susan Harkins
ssharkins at bellsouth.net
Fri Dec 10 10:43:42 CST 2004
Good idea. :) Susan H. Using Susan's suggestion, I'd make it a tad bit different. When creating the combo box, for the Row Source use a SQL statement using a group-by to refer back to the same field that's being updated. The user can still type in anything that is needed. Do a requery on the On Enter event. This way all titles used are available and new ones can be added.