ACC2000: GoToRecord Macro Does Not Work on Subform
ID: Q209765
|
The information in this article applies to:
SYMPTOMS
Moderate: Requires basic macro, coding, and interoperability skills.
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
- 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>
- Open the Quarterly Orders form.
- On the Tools Menu, click Macro, and then click Run Macro.
- Click Macro1, and then click OK.
Note that you receive the following error message:
Object 'Quarterly Orders Subform' isn't open
- 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.
Additional query words:
prb
Keywords : kberrmsg kbusage kbdta FmsEvnt
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbprb