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