diverdan
Active member
Hi there
I need some advise with a small task I am trying to achieve.
I have a form called frmCustomers. On the form there are 2 datagrids (grdOrders & grdPayments) I also have a textbox called txtCurrentBalance. What I would like to do is to be able to display a customers current balance due.
How is the best way to do this?
Do I query back to the SQL2000 database or can a formula be created that uses the values from the datagrids?
If anyone has an idiots guide to doing this I would be most grateful.
Thank you
I need some advise with a small task I am trying to achieve.
I have a form called frmCustomers. On the form there are 2 datagrids (grdOrders & grdPayments) I also have a textbox called txtCurrentBalance. What I would like to do is to be able to display a customers current balance due.
How is the best way to do this?
Do I query back to the SQL2000 database or can a formula be created that uses the values from the datagrids?
If anyone has an idiots guide to doing this I would be most grateful.
Thank you