excute goto next on subform2

[newegyptian]

Hi
How i can excute goto next record on subform2



I tried

Forms!mainform!subform1!subform2.setfocus
Docmd.runcommand accmdrecordgotonext


But failed

Please help

[Missinglinq]

Well, to begin with, if you moved off of the line

Docmd.runcommand accmdrecordgotonext

you would notice that the accmdrecordgotonext part doesn't become

acCmdRecordGoToNext

That's because there's no such command! Try using

DoCmd.GoToRecord , , acNext

Where and on what event are you attempting this?

Linq ;0)>

[newegyptian]

I tried this but failed

I want to excute on subform2

[moke123]

Where and on what event are you attempting this?

I want to excute on subform2

I believe Ling means where are you calling this , on which form - Main or Sub form, and what event - Button click or something else.

[Missinglinq]

The code for moving to the Next Record is correct...I believe your subform referencing is also off. Here's an excellent reference site for working with Subforms and SubSubForms:

http://access.mvps.org/access/forms/frm0031.htm

Linq ;0)>

[moke123]

Bear in mind that you may also need to trap error (2105?) if there is no next record.