ACC2000: GoToRecord Macro Does Not Work on Subform (209765)



The information in this article applies to:

  • Microsoft Access 2000

This article was previously published under Q209765
Moderate: Requires basic macro, coding, and interoperability skills.

SYMPTOMS

If you create a GoToRecord macro that points to a subform and run that macro from the main form, you may receive the following error message:
Object '<Subform Name>' isn't open

RESOLUTION

Use a GoToControl macro action to specify the subform control name, and then use the GoToRecord action to move to the next record within the subform. Leave the ObjectType and ObjectName arguments of the GoToRecord action blank and set the Record argument to Next.

MORE INFORMATION

The "GoToControl Action" Help topic contains a tip which reads as follows:
   Tip   You can use the GoToControl action to move to a subform, which is
   a type of control. You can then use the GoToRecord action to move to a
   particular record in the subform.
				
This is correct, but it is necessary to leave the ObjectType and ObjectName arguments for the GoToRecord action blank for this to work successfully.

Steps to Reproduce Behavior

  1. Open the sample database Northwind.mdb, and then create the following new macro:
       Macro Name     Condition     Action
       ---------------------------------------
       Macro1                       GoToRecord
    
       Macro1 Actions
       -----------------------------------------
       GoToRecord
          Object Type: Form
          Object Name: Quarterly Orders Subform
               Record: Next
               Offset: <blank>
    					
  2. Open the Quarterly Orders form.
  3. On the Tools Menu, click Macro, and then click Run Macro.
  4. Click Macro1, and then click OK.

    Note that you receive the following error message:
    Object 'Quarterly Orders Subform' isn't open
  5. Change Macro1 as follows:
       Macro Name     Condition     Action
       -----------------------------------------
       Macro1                       GoToControl
                                    GoToRecord
    
       Macro1 Actions
       -----------------------------------------
       GoToControl
          Control Name: Quarterly Orders Subform
       GoToRecord
           Object Type: <blank>
           Object Name: <blank>
                Record: Next
                Offset: <blank>
    					
Run the macro in the same way as before. Note that the macro moves the focus to the next record in the Quarterly Orders Subform.

Modification Type:MajorLast Reviewed:6/24/2004
Keywords:kberrmsg kbprb kbusage KB209765