Hey KeithG --
I got the PassThrough query and Append query to work as designed...finally! Just one thing keeps occurring when the query runs, a window opens up asking me to Select Data Source. I have to choose the data source I created, then everything works great. Any idea how to stop this from happening?
Also, I tried to assign the PassThrough query as the Record Source at the FORM level, but it won't take the assignment. The Select Data Source window keeps looping, and I have to end Access via Task Manager to exit. Any clues on this one?