Form help for similar entry lookup

[Avian Flu]

I've been attempting to make a form with the form wizard, and most of it has been going swimmingly until I realized I could run into a potential problem.

So I have an Office ID and Office Name in one table and another table with all the information in the those offices. I've linked them together in the form so that when a new office is created, the subform brings up all the entries under that office and people can make new records from there.

What the problem is that if someone writes in a new office name or types in the same ID (The ID number isn't an autonumber.), but it already happens to be in the list, it'll make a new record in the Office ID/Name table. And when it's saved, Access will give an error saying the record already exists.

Is there a way to prevent that from happening in the form? Such as if someone types in the ID Number and it already exists in the table, it'll just bring it over to that record? There are a lot of Offices in this list, so it would be time consuming to sift through each one of them.

Any input or help would be greatly appreciated!

Thanks!

 

[llkhoutx]

The name control should be a combo box where user can select a name and alternatively input a name on the combo box NotInList event.

 

[Avian Flu]

x_x' Since I am such a newbie at this....How would I go about setting up the NotInList event for the Combo box?