Prev: Use Table field in query criteria
Next: Count Query
From: Faraz A. Qureshi on 12 Feb 2010 04:49
In my following query [Forms]![Fltr]![Client] is indicated to be not
recognized while the same had been selected via expression builder. Any idea?

SELECT Fltr.ACC, Fltr.DT, Fltr.CR, Fltr.DR, COA.AcNo, COA.Cl, COA.Acc,
COA.Ntr, Clients.ID
FROM Clients INNER JOIN (COA LEFT JOIN Fltr ON COA.AcNo = Fltr.ACC) ON
Clients.ID = COA.Cl
WHERE (((COA.Cl)=[Forms]![Fltr]![Client]));

--
Thanx & Best Regards,

Faraz!
From: John Spencer on 12 Feb 2010 08:10
First, is the form Fltr open when you try to run the query. It must be for
this to work.

IF the form is open, then what message or error are you getting that indicates
that the reference to the form control is not recognized?

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

Faraz A. Qureshi wrote:
> In my following query [Forms]![Fltr]![Client] is indicated to be not
> recognized while the same had been selected via expression builder. Any idea?
>
> SELECT Fltr.ACC, Fltr.DT, Fltr.CR, Fltr.DR, COA.AcNo, COA.Cl, COA.Acc,
> COA.Ntr, Clients.ID
> FROM Clients INNER JOIN (COA LEFT JOIN Fltr ON COA.AcNo = Fltr.ACC) ON
> Clients.ID = COA.Cl
> WHERE (((COA.Cl)=[Forms]![Fltr]![Client]));
>
 | 
Pages: 1
Prev: Use Table field in query criteria
Next: Count Query