It's nothing to to do with your code, it's in your query. There could be a field which isn't related to any of the tables in the query or the way you wrote the query makes Access think it's a paramater. Paste the sql of the query that you think is showing this error on here.