GoToRecord question

[JumpinJimRivers]

Greetings,

On an afterupdate event from a subform datasheet, I want to make another subform go to the NEXT record and then read some of those fields into a NEW record in another subform. I think I know howto read in the data, but having trouble with docmd.gotorecord finding my subform. Can someone please help?

 

[papparuff]

I believe you need to set the focus to the subform you want to do the go to next records before you can do the actual command. Then the command is

DoCmd.GoToRecord , , acNext
John Ruff - The Eternal Optimist