Google Answers Logo
View Question
 
Q: Access 2000 question ( No Answer,   1 Comment )
Question  
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!
Answer  
There is no answer at this time.

Comments  
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.

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

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 Answers  


Google Home - Answers FAQ - Terms of Service - Privacy Policy