form not working-urgent please

[Guest]

I have a form that I reused (after making changes). In it, I have a couple
sub forms, one in the header and another in the footer. In the detail
section, I have a query that is a filter of one table. In the header
section, I am trying to sum one of the fields in the detail section. It
gives me an "ERROR#". It workd in the other form and I have checked many
times to see if I am doing anything wrong. What could be the reason.

Thanks for your help

 

[John Vinson]

I have a form that I reused (after making changes). In it, I have a couple
sub forms, one in the header and another in the footer. In the detail
section, I have a query that is a filter of one table. In the header
section, I am trying to sum one of the fields in the detail section. It
gives me an "ERROR#". It workd in the other form and I have checked many
times to see if I am doing anything wrong. What could be the reason.

Well, the reason could be that you have an error in the Control Source
property of that textbox. Since we cannot see your database, it's more
than a bit difficult to suggest what that error might be!

Please post the Control Source property of the textbox, and probably
also the SQL view of the Form's Recordsource query.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps