Check if name exists, if it does autocomplete, if it doesn't allow user to add new name

[LargelyClearSkies]

Hi, could someone help me out please?

I have a table full of contact details, with a unique contact ID, FirstName, LastName, Email address etc.
Another table contains company details; Company Name, Address etc and this is linked to the contacts table by the Contact ID



Then a form pulls everything together so I can see that Company A is at Front Street and Joe Bloggs is their main contact.

As it stands, this is fine. But if Joe Bloggs also started working for Company B and I add his details to the form for Company B, he is duplicated in the Contacts table with a new Contact ID.

What I'd like to do is open the form, start typing Joe's name into the contact field and somehow:

• check if this name exists
• if it does, then autocomplete the rest of the fields (phone number/email)
• if it doesn't then allow me to add a new contact

All help gratefully appreciated!

[ItsMe]

In Access 2013 there is an Autocomplete control for fields of type Text. However, It seems what you may need is a combobox control and maybe a Not In List event handler.
https://www.accessforums.net/program...tml#post276848