I want to build a form where I type in a name and the form populates the corresponding fields to that name (address, age, etc..). I have it working if I only keep the fields from within the same table. The problem is with the fields from other tables which are added onto the form as sub forms and are also on separate tabbed pages. How do I connect these so when I type the name in all of the fields fill in and allow editing? I built the form originally for entering in a new client, and it works fine. Now i want to use the same form to lookup a client and have the fields filled in.

Here is the code in my text box that works on the fields from the same table:
SELECT [patientInfo].[patientID], [patientInfo].[firstName], [patientInfo].[lastName] FROM patientInfo;