[AccessD] Text Boxes displaying in 2003 and not in 2007

What about

	Me.Recalc

as the last line in the Sub ComputePay (assuming that sub is local to the form)? 

Also, have you put a Debug.Print statement inside the AfterUpdate event handler to be sure it is being called?

Lambert

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
Sent: Thursday, December 30, 2010 1:16 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Text Boxes displaying in 2003 and not in 2007

David:

The first three text boxes, where the problem lies, are bound (=Sum([fieldname]).  I put DoEvents into the AftertUpdate event of the text box but didn't help.  Also tried DoEvents in the Form_Update event - no soap.

Rocky


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of David McAfee
Sent: Thursday, December 30, 2010 9:56 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Text Boxes displaying in 2003 and not in 2007

I've been seeing weird repaint/refresh problems too in A2K7.

Can you try using a DoEvents after each field is updated?


On Thu, Dec 30, 2010 at 9:21 AM, Rocky Smolin <rockysmolin at bchacc.com>wrote:

> Dear List:
>
> I have an app which I developed and delivered to the client in A2K3.  
> He runs is mostly in A2K7.  This is a legal app which, among other 
> things tracks time spent.  The problem is on the Timesheet form where 
> the lawyer enters time by client and matter.
>
> In the Timesheet Form Header section there are four text boxes:
>
> txtHoursWorked - control source is =Sum([HoursWorked]) 
> txtHoursBillable - control source is =Sum([HoursBillable]) 
> txtAmountBilled - control source is =Sum([AmountBilled]) 
> txtAmountToPay which is unbound and is update by a call to a module 
> ComputePay
>
> The first three change after an update of one of those three fields in 
> a detail section.  Whenever a field which affects one of these fields 
> is updated, I call ComputePay and this updates the unbound text box 
> txtAmountToPay.
>
> This works perfectly in 2003.  In 2007, however, after an update the 
> values in the first three boxes disappear and the fourth one doesn't 
> change.  But they're actually there.  If I alt-Tab away from the form 
> and then alt-Tab back, the numbers appear.
>
> I have tried Me.Repaint and Me.Refresh in the ComputePay routine but 
> no soap.
>
> I confirmed that this happens on my test bed machine as well as on his
box.
> Both are running SP2.
>
> Any ideas what might be causing this?
>
> MTIA
>
>
> Rocky Smolin
>
> Beach Access Software
>
> 858-259-4334
>
> Skype: rocky.smolin
>
> 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
>
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

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