Yep, it’s possible—just a bit tricky in Access. You can’t really change table links directly in the expression builder or the subform’s Open event because by then Access is already trying to run the query.
Instead, try modifying the table links before the subform loads—ideally in the main...