I am working on a report what looks at a couple different tables (tableA, tableB) and copies the information needed to my report table (tableX). This report has a lot of different conditions so I found myself using the same code over and over. I thought that I could take this code and put it in a local function on the form where I run my report however, I keep getting an error. All I want the function to do is appends a blank on to tableX and copy information from the other tables to this one. I thought it would be easy but I'm having some difficulty with it. Can anyone help me with this?