Auto Fill - Form Fields

I have created a database that does all that I want it to except one thing.

When entering information into a “Name Field” on a FORM I would like it to automatically complete the name if it is one that already exists in a specific TABLE. Then when TAB is pressed I would like it to auto-complete the remaining fields with other information Relating to the “Name Field” such as Address and Postcode.

I can do both these things separately but cannot get them to work together.

EG if I use a Combo Box or lookup, I can auto fill the field as I type but if I then try to use this in tandem with the small piece of visual basic to complete the other fields it will not work.

The Visual basic works fine if I type all the “Name Filed” information in manually when you hit tab the appropriate fields Auto- Complete.

I hope what I have written can be understood and thank you in advance for any Help

Regards Dean