dual table query in subform

[groengoen]

I want to do a query on a subform which picks up an ID field on the main form without using this as the connecting master, child key but finds this ID in one of two fields in the full table. My problem is, how to pass this field value from the master form to the query. I would use OpenArgs if I was calling another form, but how would one do this in a subform?

I would be most grateful for any assistance as this problem has been puzzling me for some time

 

[RuralGuy]

Can you add the table to the query of the SubForm and join them?