Not getting amount from open form

S

SAC

I'm trying to build a query using an amount from an open form and I get no
value when I run the query.

Here's the sql statement:

SELECT [Forms]![frmEstrHComm]![txtSumLabCost] AS Expr1, tblEstrHComm.EstNo
FROM tblEstrHComm
WHERE (((tblEstrHComm.EstNo)=[Forms]![frmEstrHComm]![EstNo]));

txtSumLabCost is a calculated control.

What am I doing wrong?

Thanks.
 
S

SAC

Also, I tried going back to the source control since this one is a calulated
one and I get four square boxes.

??
 
Top