doofusboy, that is the method i have tried but it just requests a value for TableA.Field_1.

I forgot to add that i am using Access