Subform to requery Main form field

[naobao]

Yes!! I check your demo & know how to do. Thanks! again!!

 

[theDBguy]

Yes!! I check your demo & know how to do. Thanks! again!!

Okay, cool. Good luck with your project.

 

[naobao]

One more thing want to ask you...
before use the code "me.parent.recalc" in after update,
when press the "enter key" it will go to the new record field,
but now I need to press the key two time!
How can I fix this?

 

[theDBguy]

One more thing want to ask you...
before use the code "me.parent.recalc" in after update,
when press the "enter key" it will go to the new record field,
but now I need to press the key two time!
How can I fix this?

Hi. I may have to see what you did. Can you post a new copy of your db?

 

[naobao]

Please check

 

[theDBguy]

Please check

Okay, it may not be exactly what you want, but this change will send the focus to a new record every time.

Private Sub Form_AfterUpdate()
'thedbguy@gmail.com
'6/20/2019

Me.Parent.Recalc
DoCmd.GoToRecord , , acNewRec

End Sub

 

[naobao]

Thanks for help!

 

[theDBguy]

Thanks for help!

You're welcome! Cheers!