Hi there,
I'm having a prob figuring out the best way to do this:
I have a form that's set to add a new record when a user opens it. On the form is a combobox (comboName) that the user can type in. If the user enters a name that's new or not already in the combobox list, everything's fine & dandy. However, if a user starts typing a name that's already entered, then I need the form and it's auto ID (NameID) to revert back to the record that's already entered. And consequently, I don't need to keep the 'new' record just added upon opening the form. Is there some code that will do the following:
check the names list for the newly entered name, and if the name is new, then add a new record and keep the name that was just entered, if it's not, then go back to the record that's already entered and display it's data.
Thanks much,
Eric
I'm having a prob figuring out the best way to do this:
I have a form that's set to add a new record when a user opens it. On the form is a combobox (comboName) that the user can type in. If the user enters a name that's new or not already in the combobox list, everything's fine & dandy. However, if a user starts typing a name that's already entered, then I need the form and it's auto ID (NameID) to revert back to the record that's already entered. And consequently, I don't need to keep the 'new' record just added upon opening the form. Is there some code that will do the following:
check the names list for the newly entered name, and if the name is new, then add a new record and keep the name that was just entered, if it's not, then go back to the record that's already entered and display it's data.
Thanks much,
Eric