Hi. I have a simple question about data controls and recordsource.
I have 2 data controls. Data1 is openned on the table "Team" and Data2 is opened on the table "Player".
I tried the following recorsource on data2:
SELECT Player_Name FROM Player WHERE Player_TeamNo = Data1!Team_No
The failing part of this recordsource is the WHERE clause. I would like to know to make such a referrence to the Data1 control.

Thanks in advance.