G Guest May 11, 2007 #1 How can I use code in the After_Update event of a control on a parent form to send the child form to a new record?
How can I use code in the After_Update event of a control on a parent form to send the child form to a new record?
S Steve May 12, 2007 #2 Put the following in the AfterUpdate event: Me!NameOfSubformControl.SetFocus Me!NameOfSubformControl!NameOfAnyControlInSubform.SetFocus DoCmd.GoToRecord , , acNewRec PC Datasheet Providing Customers A Resource For Help With Access, Excel And Word Applications (e-mail address removed)
Put the following in the AfterUpdate event: Me!NameOfSubformControl.SetFocus Me!NameOfSubformControl!NameOfAnyControlInSubform.SetFocus DoCmd.GoToRecord , , acNewRec PC Datasheet Providing Customers A Resource For Help With Access, Excel And Word Applications (e-mail address removed)
