query

[Guest]

my database is to keep track of check deposits. I have 1 table for the
deposit with the fields, CASH TOTAL, CHECK TOTAL, AND DEPOSIT TOTAL, and
Transaction number. The other table, CHECKS, IS LINKED BY TRANSACTION NUMBER
TO THE PREVIOUS TABLE. My problem is that I created a query to sum all the
individual check amount entries, and it works fine when I run the query
outside of a form, but in a form I get #Name? error.

 

[MGFoster]

my database is to keep track of check deposits. I have 1 table for the
deposit with the fields, CASH TOTAL, CHECK TOTAL, AND DEPOSIT TOTAL, and
Transaction number. The other table, CHECKS, IS LINKED BY TRANSACTION NUMBER
TO THE PREVIOUS TABLE. My problem is that I created a query to sum all the
individual check amount entries, and it works fine when I run the query
outside of a form, but in a form I get #Name? error.

The #Name? error means the control that is showing that error is
expecting a column in the query w/ the name as is in the control's
ControlSource property. Just make sure the ControlSource column name is
one of the columns in the query's result set.