Ok that worked nicely. Thank you. That was really simple. What I had actually done was copy an existing form that added data to a table and tried to modify the VBA behind it. Turns out I was making more work for myself than there had to be.

One more question though, I now have a form that populates the table correctly except now every time that form appears it is filled with an existing table entry from a previous query. I just want them to be blank. I'm sure this is probably just as simple but I'm struggling. I do greatly appreciate your help thus far though.