Re: Requery Total on Parent

Tech-Archive recommends: Speed Up your PC by fixing your registry

The Change event should be ok. (Or AfterUpdate, if you want to wait
until the user has finished typing the new value & then goes to exit
the field.)

Try: Me.Recalc instead of Requery.

HTH,
TC (MVP Access)
http://tc2.atspace.com

.

Relevant Pages

  • Re: Spell Checker
    ... Marsh it is in the Afterupdate event, there is no code in any other event. ... Use the AfterUpdate (or maybe Exit) event instead. ... Now you can use the spell checker the way you want.>> Bob wrote: ... Comments4 at the moment it spell checks the whole form. ...
    (microsoft.public.access.formscoding)
  • Re: Spell Checker
    ... If you are using either the text box's AfterUpdate or Exit ... Bob wrote: ... Comments4 at the moment it spell checks the whole form. ...
    (microsoft.public.access.formscoding)
  • Re: Spell Checker
    ... but the BeforeUpdate event is the wrong ... Use the AfterUpdate (or maybe Exit) event instead. ... Now you can use the spell checker the way you want.>> Bob wrote: ...
    (microsoft.public.access.formscoding)
  • Change Event cant reference .text property
    ... I have a procedure to set the RecordSource of a form in the AfterUpdate ... Using the Change event of the came Combobox I want the ... You can't reference the a propety or method for a control unless the control ...
    (microsoft.public.access.forms)
  • Re: Writing code for Events in Class
    ... I use the Change event in the class and AfterUpdate in the ... A pain, but unavoidable I believe. ... TextBox outside its Container? ...
    (microsoft.public.excel.programming)