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

Brilliant AD
You've been my 'lifesaver' these last 2 days 
Many many thanks

Darren
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of A.D.TEJPAL
Sent: Friday, 12 May 2006 4:01 AM
To: Access Developers discussion and problem solving
Cc: ADT
Subject: Re: [AccessD] A2003:Syntax for NEXT on a subform called from mainform

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
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com