Move to next record on subform

[Wavequation]

I have a form with a subform. The subform is a continuous form with many
records. I have another form which displays detailed information about the
record which is current in the subform. I would like to be able to move to
the next record of the subform from the second form. I am try to use
docmd.gotorecord, but I am having trouble referencing the subform... What
syntax should I use?

 

[Jeff Boyce]

Check Access HELP for "expressions" for exact syntax. As I recall, it goes
something like:

Forms!YourMainForm!YourSubformControlName.Form!YourControlOnSubform

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Steve Sanford]

Also see: "Refer to Form and Subform properties and controls" at

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

HTH