I have a form which shows fields that contain people's contact information. What I would like to do is have the last name field be a lookup field you can use to choose which person's info to look at. You type in a last name, it autocompletes, you either hit enter when the autocomplete is correct, or scroll through the drop down list to choose a name. This I can do. The problem is, I also want this field to be bound to the last name column of a table so that if someone is entering a new contact, the information they type in this field is stored as a new last name and they can fill in the rest of the information. It seems like this should be possible, but I can't seem to get all the stuff right. It seems I can only get it to be a field that they enter information into or a field that opens a record. is there a way to do both?