I am creating a form where the details are based on Table1. However, from each detail, I want corresponding data from Table2 shown in text boxes.
How do i use SQL expressions from the Control Source for these text boxes ?

for example, I want to have;

Select Table2.First_Name from Table2 where Table2.ID = Table1.ID


thanks