Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

#error in form? 1

Status
Not open for further replies.
OAKLEYS21

OAKLEYS21

MIS
Jun 28, 2004
20
CA
Hello

Why do I get a #error message in the text bax with the following formula in my form? formula =sum([AMOUNT]) where AMOUNT is the field in my table called transactions the field contains both negative and positive values. That exact formula works with my report. Why is it like that for my form? Thanks.
 
Sort by date Sort by votes
Do you have the forms record source set to the correct table? Is the name of the field typed correctly?

Stephen [infinity]
"Jesus saith unto him, I am the way, the truth, and the life:
no man cometh unto the Father, but by me." John 14:6 KJV
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Kennelbloke
  • Locked
  • Solved
Subform not updating in parent form
Replies
10
Views
1K
Kennelbloke
Kennelbloke
TrekBiker
  • Locked
  • Question
Form Data Not Updating
Replies
6
Views
799
dhookom
dhookom
TrekBiker
  • Locked
  • Question
Forcing Form Updates
Replies
2
Views
620
TrekBiker
TrekBiker
breezett93
  • Locked
  • Question
Function that find all controls on a form and puts their tab index in numerical order
Replies
19
Views
1K
dhookom
dhookom
TinaS
  • Locked
  • Question
Quick one I think - question about Properties window in Form Design view
Replies
1
Views
354
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top