I got it to work, sort of. The form was looking directly at the table so I changed it to look at a query based on the table. I also moved your lines of code Tyler to the After Update event of the name field.
Now for the new problem when I select a user name from the drop down list, say Andy...