How to Calculate UnBound Form Fields when Data Changes
Posted on 2006-07-11
I'm using VB 2005.
I have a database Application which displays an Invoice. I'm only saving Certain Fields in the db, For this example assume it's a Subtotal amount and Freight amount.
I have an unbound Text Field Call Total, which I have a procedure to calculate it's total.
I'm using all components for the database connection ie. datasets, bindingsource, tableadapter, and navigator.
MY question simply is, where the best place to call my procedure to Calculate the Total whenever the database loads a new record.
I'm thinking on the Bindingsource.posistionChanged but I'm not sure.
Anyother pointers would be helpful.