By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,082 Members | 2,108 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,082 IT Pros & Developers. It's quick & easy.

compare field values while editing records on a subform

P: 4
I have a sub form that serves as a schedule for annual production, listing items, a planned total (given to use by our corporate overlords), and then separate totals for each month of the year that our facility plans. I'd like to alter the font of the total field if the sum of the month fields doesn't match the total. Is there a way to do this on the fly while the user changes values in the month fields of a given record? If not, any good suggestions on a visual warning of totals not matching the some of the months?

Thanks in advance!
Oct 23 '08 #1
Share this Question
Share on Google+
2 Replies


DonRayner
Expert 100+
P: 489
If your subform is based on a query, then add a calculated field for the total of all the months and place it next to the planned total. With an actual and planned total side by side it should be easy to notice.

Depending on how important this is you could always then use your forms timer control to check for discrepancies between the totals and then popup a warning form letting the user know about it.
Oct 24 '08 #2

NeoPa
Expert Mod 15k+
P: 31,494
If it's a continuous form (the subform) then you will almost certainly need to use conditional formatting.

Otherwise an OnCurrent event procedure could change it on the fly.

If updates are allowed on this subform then AfterUpdate events on the relevant controls may also be necessary.
Oct 24 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.