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 Mike Lewis 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
Oct 3, 2005
5
0
0
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