form not working-urgent please

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
Click to expand...

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
 
Back
Top