DataSheet Sumary
in [Forms]
|
Prev: colours in the fomrs
Next: Repeat afterupdate code
From: Cesarini on 12 May 2010 14:07 Hi Guys/Girls, Access 2007 I have a Datasheet form into another as a subform I have a sumary texbox unbound in the first Datasheet, that takes the its value from another unbound texbox placed into the subform. This works just fine.The problem I need to solve is the sumary. This shows the value until I click on the plus sign ("+") meanwhile it shows and error (#Error). I need the sumary textbox recalculates its value always.As usual I will appreciate your helpsRegards, ------------------ César Parrales
From: mie via AccessMonster.com on 13 May 2010 04:16 Arvin , can we change the code from : =Forms!FormName!SubformName.Form!txtTextBoxName to =Forms!FormName!SubformName!txtTextBoxName Arvin Meyer [MVP] wrote: >Try doing it again. Make sure that you are using the subform control's name, >not the name of the subform, (although they are often the same). >> Thanks for your Answer Arvin: >> >[quoted text clipped - 36 lines] >>> >>> . -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/201005/1
From: Douglas J. Steele on 13 May 2010 07:45 Why would you? The former is the correct syntax. -- Doug Steele, Microsoft Access MVP http://www.AccessMVP.com/DJSteele (no e-mails, please!) "mie via AccessMonster.com" <u58255(a)uwe> wrote in message news:a7eeec6c3d848(a)uwe... > Arvin , can we change the code > > from : > =Forms!FormName!SubformName.Form!txtTextBoxName > > to > =Forms!FormName!SubformName!txtTextBoxName > > > > > Arvin Meyer [MVP] wrote: >>Try doing it again. Make sure that you are using the subform control's >>name, >>not the name of the subform, (although they are often the same). >>> Thanks for your Answer Arvin: >>> >>[quoted text clipped - 36 lines] >>>> >>>> . > > -- > Message posted via AccessMonster.com > http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/201005/1 >
From: mie via AccessMonster.com on 13 May 2010 08:52 i did simple test, both gave the same results.. Douglas J. Steele wrote: >Why would you? The former is the correct syntax. > >> Arvin , can we change the code >> >[quoted text clipped - 12 lines] >>>>> >>>>> . -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/201005/1
From: Douglas J. Steele on 13 May 2010 09:19
What version of Access? Older versions let you be sloppy with the syntax: Access 2007 (and presumably Access 2010) is much fussier, so using the correct syntax is always a good idea. Is there a particular reason why you don't want to use the correct syntax? -- Doug Steele, Microsoft Access MVP http://www.AccessMVP.com/DJSteele (no e-mails, please!) "mie via AccessMonster.com" <u58255(a)uwe> wrote in message news:a7f15626ecb54(a)uwe... >i did simple test, both gave the same results.. > > Douglas J. Steele wrote: >>Why would you? The former is the correct syntax. >> >>> Arvin , can we change the code >>> >>[quoted text clipped - 12 lines] >>>>>> >>>>>> . > > -- > Message posted via AccessMonster.com > http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/201005/1 > |