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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

validate form totals

Status
Not open for further replies.
slyscurry

slyscurry

Programmer
Aug 7, 2008
5
US

Hi,
I have a form with a subform that's a datasheet. I have one field in the parent form that equals a number (called "transactionAmount"). I have a column of numbers in the sub form data sheet. I have been able to create a new field (called "lineItemTotal") placed in the parent form footer that adds these sub form values up.
I am now trying to validate my form to make sure transactionAmount = lineItemTotal before a user clicks to a new record. If they don't equal i don't want a new record to appear, but instead a message saying "these amounts must total", or something to that extent.

Thanks!
 
Status
Not open for further replies.

Similar threads

ameedoo3000
  • Locked
  • Question
format partition by vba code
Replies
6
Views
383
mattKnight
mattKnight
digitalias
  • Locked
  • Question
Temporarily retain Date value in data entry form
Replies
0
Views
72
digitalias
digitalias
lameid
  • Locked
  • Helpful tip
Richtext Format in tables - Default vs. Embedded font...
Replies
0
Views
108
lameid
lameid
BradCustom
  • Locked
  • Question
Form Field limited to 255 characters
3 4 5
Replies
98
Views
872
Andrzejek
Andrzejek
Moss100
  • Locked
  • Question
Who has the largest Access Database in terms of objects (forms etc)???
Replies
2
Views
114
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top