Updating field in form from summary value in another 
Author Message
 Updating field in form from summary value in another

Please help me out here folks...

I've got two forms on the same page of a tab control. Form
1 has the field [Price] on it. Form 2 has the field
[Componentprice] on it. In Form 2's footer, I have a sum
(Componentprice) function in a field [Comppricesum]. The
function is summing fine.

I would like the [Price] field to get the new total every
time I add or change the component prices. I have attached
an assign statment to the "AfterUpdate" event of Form 2,
to get Form1![Price] = Form2![CompPriceSum]. What happens
is that [Price] always gets the previous value of
[CompPriceSum] instead of the current one.

Thanks in advance -



Wed, 27 Jul 2005 07:03:29 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Problem updating Form field value with DHTML

2. Update datagrid recordset and 1 summary textbox field

3. adodb connection to excel: recordset.fields(i).value=null for fields with numeric value

4. adodb connection to excel: recordset.fields(i).value=null for fields with numeric value

5. adodb connection to excel: recordset.fields(i).value=null for fields with numeric value

6. Update Field Value

7. Help with updating a field value

8. Updating Fields with Different Values?

9. Variable and field value changes after .Update in VBA

10. need help on getting the auto-increment value of a field BEFORE updating recordset

11. Updating Field Values

12. When value changes, update other field with current date

 

 
Powered by phpBB® Forum Software