Thank you orange! You fixed my problem!!! I think my problem was two-fold;

1) I was using CurrentDb.QueryDefs, not CurrentDb.CreateQueryDef. I was creating a new query, not accessing an existing one. This is why it worked for the original query, but not the altered query.

2) I was trying to use the OpenRecordset method by passing it the SQL string, instead of the table name.

I will mark this resolved!