Have to update field twice on subform to see change on main form

[Valerie]

When I update a field on my subform, I use the AfterUpdate event to calculate a new value of a bound field on the Main form.

I have to enter the new value on the subform TWICE, before I see the new calculated value on the main form.

Any ideas?

Thanks in advance.

 

[Uncle Gizmo]

You will probably have to refresh the main form, so add a line to your after update event Something like :

Form_MainForm.refresh

 

[Valerie]

I've tried that already - but I still need to update the field twice!

 

[Uncle Gizmo]

The syntax of "Form_MainForm.refresh" this is difficult to get right , I can't remember where it is but I know I've got a list of the syntax variations somewhere I have a look .

 

[Uncle Gizmo]

Syntax for subs

 

[Valerie]

Thanks for the syntax - I've already got the syntax correct for refresh, but this doesn't seem to be the problem.

 

[Uncle Gizmo]

All I can suggest is that you post your DB , alternatively study the Microsoft north winds example which I believe has a similar main form subform example and see it you can spot the difference !

 

[Valerie]

My db is very big now so not sensible to post it!

Had a quick look at Northwinds - nice simple example - I wish mine were as simple!

Just had a different thought on the problem - when I click on to the main form, I see the 'pencil' indicating the record is being edited - do you know if there is anyway I can save this record from the main form?

 

[shakeelmscw]

I am also facing the same problem, i need to update twice to see the change. did you got some solution to this problem??

 

[shakeelmscw]

I have a table, from table i have created a query. from query i have made one form to update the values in main table. on that form i have a subform. from that subform i need to update the main table fields.

 

[shakeelmscw]

subform values are depends on selection of a class from the main table. below i will post the picture of the form/subform

 

[shakeelmscw]

http://www.freeimagehosting.net/u1jx9

http://www.freeimagehosting.net/u1jx9

I need to select class two times to get the standard fee and other field updated in the main table for subform fields. i used blow codes to update the field.
[Standard_Fee] = Forms![student record]![Classesf].Form![Standard_Fee1]
[Security_Deposit] = Forms![student record]![Classesf].Form![Security_Deposit1]
[Annual_Fee] = Forms![student record]![Classesf].Form![Annual_Fee1]
[Admission_Fee] = Forms![student record]![Classesf].Form![Admission_Fee1]