Not getting amount from open form

  • Thread starter Thread starter SAC
  • Start date Start date
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.
 
Also, I tried going back to the source control since this one is a calulated
one and I get four square boxes.

??
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Parameter Value error in a Subform 0
Access Query problem 1
A Real Stumper 3
bitwise operator in SQL 3
Form's new SQL recordsource returns nothing 5
Access #Error & Excel Pivot 0
Cascade queries 7
Access Open Form with WhereCondition 6

Back
Top