Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Save record problem

Status
Not open for further replies.

koci

Programmer
Joined
Oct 3, 2005
Messages
5
Location
ES
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!


.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top