Hi all!
I have one view: IDProduct, Cant, Price, Total
where Total = Cant*Price
I have one form with recordsource the view above
When I insert/update a record from this form
1)In Access
-----------
the textbox Total(calculated field) is automaticaly updated when I update either Cant or Price textbox
2) In ADP
----------
the textbox Total is NOT automaticaly updated when I update either Cant or Price textbox, until I not save (or change) the current record.
Can anybody tell how to make this to be automaticaly?
Sorry for my poor english
PS. I have one workaround for this but is little
In AfterUpdate's event of two's textbox (Cant and Price), I put the following code:
DoCmd.GoToRecord , , acNext
DoCmd.GoToRecord , , acPrevious
Thank's in advance!
.
I have one view: IDProduct, Cant, Price, Total
where Total = Cant*Price
I have one form with recordsource the view above
When I insert/update a record from this form
1)In Access
-----------
the textbox Total(calculated field) is automaticaly updated when I update either Cant or Price textbox
2) In ADP
----------
the textbox Total is NOT automaticaly updated when I update either Cant or Price textbox, until I not save (or change) the current record.
Can anybody tell how to make this to be automaticaly?
Sorry for my poor english
PS. I have one workaround for this but is little
In AfterUpdate's event of two's textbox (Cant and Price), I put the following code:
DoCmd.GoToRecord , , acNext
DoCmd.GoToRecord , , acPrevious
Thank's in advance!
.