Why does your subform need a Join Query?
Shouldn't the query just be based on the Commissions Table or it's query.
The Join for the subform should be established by the Form's Master/Child links?