-
1
- #1
On a form I am creating a sales record that has multiple lines (using a tempRS based on an ACCESS database). I have 5 txtBoxes (Product, Quantity, UnitPrice, LineTotal, JobTotal) that populate (via cmdButton) a DataGrid (Adodc control). The "JobTotal" txtBox and column contain a running tally of the sales record.
After a row is on the DataGrid I would like to be able to edit one of the columns (cells - i.e. Quantity or UnitPrice) and have it re-calculate the LineTotal and JobTotal columns and JobTotal txtBox. I'm fairly new to VB and would greatly appreciate some help from someone OR tell me where to find help with DataGrids. THANKS!!
After a row is on the DataGrid I would like to be able to edit one of the columns (cells - i.e. Quantity or UnitPrice) and have it re-calculate the LineTotal and JobTotal columns and JobTotal txtBox. I'm fairly new to VB and would greatly appreciate some help from someone OR tell me where to find help with DataGrids. THANKS!!