|
|
Subject:
Access 2000 question
Category: Computers > Programming Asked by: lemonysnicket73-ga List Price: $2.00 |
Posted:
07 Apr 2005 22:09 PDT
Expires: 07 May 2005 22:09 PDT Question ID: 506610 |
This is an Access 2000 question. I'm calling a macro from within a subform on another form, and asking it to do something with that subform. The manual says that if a macro affects a form, that form has to be open. No problem--the button is on the form that I'm affecting, so it has to be open. However, I get an error which says that my form *isn't* open, and I can't figure out why: "The macro you are running (directly or indirectly) contains a GoToRecord, Repaint Object, or SelectedObject action, but the Object Name argument names an object that is closed. The object name argument for the GoToRecord, Repain Object, or SelectObject method names an Object that is closed. Use of the Open Action method to open the object so that you can carry out the desired action." Anyone know what the problem is? Thanks! |
|
There is no answer at this time. |
|
Subject:
Re: Access 2000 question
From: willcodeforfood-ga on 07 Apr 2005 23:09 PDT |
If you are trying to navigate to a record in the subform with a macro using the GoToRecord action, read this Microsoft support article. The article states that it applies to Access 97 but I suspect that since the behavior is "by design" that it applies to later versions of Access as well: [ http://support.microsoft.com/default.aspx?scid=kb;EN-US;92685 ] The article advises that you "... 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." If you are trying to do something different, please provide a little more detail. It is not always possible to figure out the problem just from the error message. Also, if you explain exactly what you are trying to accomplish, someone might have insight to an easier way to accomplish the same thing. |
If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you. |
Search Google Answers for |
Google Home - Answers FAQ - Terms of Service - Privacy Policy |