I modified my code, so that it looks like what's below. I know the query works because i can run it by itself to append the Password table (i just have to enter the Volunteer.ID value). However, when i actually use the form, i get an error after it runs through the query that says "Run-time error '13': Type Mismatch" and i do not know what this means nor do i understand how to fix it. Any help?


Thanks,
...

Hi, I have been trying to figure this out for hours, but can't seem to get it. I have a form where the administrator inputs someone elses personal info (FirstName, lastName, email, phone#, etc.) and when they click enter, I have it so a new entry is created in my Volunteer table. What i would like to do it, is when the admin clicks the enter button, a new entry will be made in the Password table. When a new record is added to the Volunteer table,...