[AccessD] A2K3 vs A2K7?

I don't understand, Rocky.  If you're calling the code behind the
subform and trying to requery the subform, there's no reason to refer to
the parent at all.  Me.Requery should be the right construction.  Put a
breakpoint in and find out what Me points to at that point.

Charlotte Foust

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
at Beach Access Software
Sent: Thursday, May 15, 2008 2:28 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] A2K3 vs A2K7?

Darryl:

I'm using 

    Forms!Matters.Matters_GroupMatters.Form.Requery

But get an "application-defined  or object-defined error" which usually
means the wrong syntax.  This is being called from a module behind the
sub form.  Main form is Matters; sub form is Matters_GroupMatters.  I'm
trying to requery the subform.



Rocky Smolin
Beach Access Software
858-259-4334
www.e-z-mrp.com
www.bchacc.com
 
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darryl
Collins
Sent: Wednesday, May 14, 2008 9:41 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] A2K3 vs A2K7?


Hey Rocky,

Just as a guess, have you tried to reference the sub form specifically?

[Forms]![frm_MainForm].[frm_SubForm].[Form].requery

I find this approach is less flakey than using Me.whatever.

regards
Darryl.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Rocky Smolin
at Beach Access Software
Sent: Thursday, 15 May 2008 2:30 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] A2K3 vs A2K7?


Dear List:
 
I have an app in development in 2003.  My client tests it in 2007 and
occasionally we find something that works in A2K3 and not in A2K7.
 
Now I have a statement in a subform on a form and after manipulating the
data in the table that is the recordsource for the sub-form I issue a
Me.Requery.  Which works in A2K3.  But when he tries it in A2K7 he gets
an error "2467: The expression you entered refers to an object that is
closed or doesn't exist".  Since the object, in this case the sub-form,
is open and does exists, I think the error might be misleading and may
actually be a result of some other condition.  But I don't know.
 
Has anyone seen this behavior?  Any theories?

MTIA
 
Rocky
 



 	
	
 

Rocky Smolin

Beach Access Software

858-259-4334

www.e-z-mrp.com <http://www.e-z-mrp.com/> 

www.bchacc.com <http://www.bchacc.com/> 

 

 

 
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

This email and any attachments may contain privileged and confidential
information and are intended for the named addressee only. If you have
received this e-mail in error, please notify the sender and delete this
e-mail immediately. Any confidentiality, privilege or copyright is not
waived or lost because this e-mail has been sent to you in error. It is
your responsibility to check this e-mail and any attachments for
viruses.  No warranty is made that this material is free from computer
virus or any other defect or error.  Any loss/damage incurred by using
this material is not the sender's responsibility.  The sender's entire
liability will be limited to resupplying the material.

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

No virus found in this incoming message.
Checked by AVG. 
Version: 7.5.524 / Virus Database: 269.23.16/1433 - Release Date:
5/14/2008
4:44 PM
 

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com