[AccessD] A2003:Syntax for NEXT on a subform called from main form

Darren,

    You can use the following syntax :

    Me.SF_Sub.Form.Recordset.MoveNext

    (SF_Sub is the name of control on the main form, serving as container for the subform).

    This does not require prior setting of focus on the subform.

A.D.Tejpal
---------------

  ----- Original Message ----- 
  From: Darren DICK 
  To: 'Access Developers discussion and problem solving' 
  Sent: Thursday, May 11, 2006 19:24
  Subject: [AccessD] A2003:Syntax for NEXT on a subform called from main form


  Hi All

  I have a mainform that has a sub form. I want the sub form to go to its next record when I push the Next button on the main form
   
  Anyone know what the syntax is?
   
  many thanks
   
  Darren