Thread: Using SQL in Expression Builder
02-14-05, 17:32 #1Registered User
- Join Date
- Sep 2003
Unanswered: Using SQL in Expression Builder
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