Actually it's the name of both the subform object and the subform. -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of martyconnelly Sent: Sunday, September 17, 2006 1:06 PM To: [email protected] Subject: [ms_access] Re: copy value of calculated text box in 2000
You might want to check on 2000 version that F_Acc_Sub is the name of the control that holds the subform not the actual subform name. Here is a short word document on subform syntax. http://www.access-programmers.co.uk/forums/showthread.php?t=102826 --- In [email protected], "Tom P" <[EMAIL PROTECTED]> wrote: > > Access2000 > I'm trying to use VB to copy the value of a calculated text box on a > sub form, to a text box on another open form. Both are formatted > currency > Text10 on the source subform is =Sum([amount]) > > Code to copy it is: > Let Forms![Find Shipment].AccCharge = [Forms]![F_AccCharges]! > [F_Acc_Sub].[Form]![Text10] It works in Access XP but not 2000? > > Thanx in advance > Tom P > Yahoo! Groups Links Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/ms_access/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
