Subform to requery Main form field (1 Viewer)

naobao

Registered User.
Local time
Today, 07:03
Joined
Feb 13, 2014
Messages
76
Yes!! I check your demo & know how to do. Thanks! again!!
 

naobao

Registered User.
Local time
Today, 07:03
Joined
Feb 13, 2014
Messages
76
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

I’m here to help
Staff member
Local time
Today, 07:03
Joined
Oct 29, 2018
Messages
21,357
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

Registered User.
Local time
Today, 07:03
Joined
Feb 13, 2014
Messages
76
Please check
 

Attachments

  • demo.accdb
    460 KB · Views: 39

theDBguy

I’m here to help
Staff member
Local time
Today, 07:03
Joined
Oct 29, 2018
Messages
21,357
Please check
Okay, it may not be exactly what you want, but this change will send the focus to a new record every time.
Code:
Private Sub Form_AfterUpdate()
'thedbguy@gmail.com
'6/20/2019

Me.Parent.Recalc
DoCmd.GoToRecord , , acNewRec

End Sub
 

Users who are viewing this thread

Top Bottom