Send subform to a new record in Access 2000

D

Del

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

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
[email protected]
 
Top