Ad-Hoc Query Builder in Access

[OBP]

Jimmy, I will email you a copy and an explanation.
My concern with AD Hoc joins is that you could match up completely unconnected fields, whereas using the Related tables you at least know that the data types and content must match.
You do not necessarily have to use the same "Join" properties as the Relationship, just pick up the Table and Field names. I have written a routine, based on the Access VBA help topic that does that. See Form1 in the database that I have sent you.