I have two tables one that stores information regaring food, portion, cal and fat(called tblpantry). The other table stores Journaling of the day(tbljournaling. I want to be able to select an item in the form that I created for journaling and have that information then stored in the journaling table. Is there a way to copy a record that is selected to a different table? If so how?