i have a Form with a data source for most the fields on the form. But I need to bring in values from another table and I am having trouble getting the right syntax.
This is what I have now:
Employer Name «Expr» [QryCAPSLlink]![Employer Name]
The query is just pulling one record.
<<Code>>
SELECT Tbl403bCAPSLlink.[Remitter/ Plan Number], Tbl403bCAPSLlink.[Employer Name]
FROM Tbl403bCAPSLlink
WHERE (((Tbl403bCAPSLlink.[Remitter/ Plan Number])="1291"));
<<Code>>
Attached are screen prints. Any help will be greatly appreciated.
Thank you
Russ