Is there a way in an access 2003 using a macro that a table ID field that if matched will autofill specified other fields? For an example please see the attachment. I am trying to limit redundancy in data entry by using a match criteria to aid in the process. Thank you in advance.

You shouldn't be auto filling fields with redundant data. You should have a normalized design ( http://support.microsoft.com/kb/283878 ) and then you store the ID of the person, not their name, nor their details since you would have them ONCE in a table and can then get their values any time by using a query.

A normalized scheme will work, but how do I accomplish this?