G
gtslabs
I have a from and Subform linked with a field called "labsampleid".
Both main and sub forms are continious.
I am trying to filter what I can put in the sub form based on the
value in a field of the current selected record in the main form.
However I dont think my SQL is correct.
Here is the code in my subform for the field I want to filter.
SELECT [tbl-TestCodes].TestCode, [tbl-TestCodes].TestName, [tbl-
TestCodes].Matrix, [tbl-TestCodes].SortOrder
FROM [tbl-TestCodes]
WHERE ((([tbl-TestCodes].Matrix)=[Forms]![F_Samples Management]!
[Matrix]))
ORDER BY [tbl-TestCodes].SortOrder;
The WHERE does not know what record I have selected above in the
F_Samples Management form.
I want to filter the subform record based on the value in the MATRIX
field for the selected record in the F Samples Management form.
Both main and sub forms are continious.
I am trying to filter what I can put in the sub form based on the
value in a field of the current selected record in the main form.
However I dont think my SQL is correct.
Here is the code in my subform for the field I want to filter.
SELECT [tbl-TestCodes].TestCode, [tbl-TestCodes].TestName, [tbl-
TestCodes].Matrix, [tbl-TestCodes].SortOrder
FROM [tbl-TestCodes]
WHERE ((([tbl-TestCodes].Matrix)=[Forms]![F_Samples Management]!
[Matrix]))
ORDER BY [tbl-TestCodes].SortOrder;
The WHERE does not know what record I have selected above in the
F_Samples Management form.
I want to filter the subform record based on the value in the MATRIX
field for the selected record in the F Samples Management form.