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 Rhinorhino 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
Joined
Aug 7, 2008
Messages
5
Location
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 Question
format partition by vba code
Replies
6
Views
1K
mattKnight
mattKnight
digitalias
  • Locked
  • Question Question
Temporarily retain Date value in data entry form
Replies
0
Views
312
digitalias
digitalias
lameid
  • Locked
  • Helpful tip Helpful tip
Richtext Format in tables - Default vs. Embedded font...
Replies
0
Views
383
lameid
lameid
BradCustom
  • Locked
  • Question Question
Form Field limited to 255 characters
3 4 5
Replies
98
Views
5K
Andrzejek
Andrzejek
Moss100
  • Locked
  • Question Question
Who has the largest Access Database in terms of objects (forms etc)???
Replies
2
Views
488
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top