I should have included that this is a variable form. No table associated with it. So there is no POST or REFRESH to perform on a table.
I put in the Timer EEP a property code to change color of the displayed variable from green to red and back. I.E. each time the timer ran, the displayed variable would change color. The variable changes color fine, so I know the timer is firing at the designated interval. However the SELECT statement obtains the max number the first time it fires, but then does not see any new records added by other users after the form is first called. The variable is calculated only in the Timer eep. So I need to somehow refresh the data buffer that the timer looks at. Thanks again. -Bob -- Thompson Technology Consultants LaPorte, IN 46350 219-363-7441 -------------- Original message -------------- From: [EMAIL PROTECTED] I have a form that I want to update a value automatically every 30 seconds. I have an EEP in the Form Timer that : --Find the maximum MO number currently being worked on Select (max(MoNumber)) into vMaxMo from MoTable recalc variables return The timer works fine...except the value for vMaxMo never changes unless I exit the form and re-enter. For example I start the form in one session of Rbase and the form displays the Max MO number as 5455. In a second session of Rbase, I add a record to the MoTable that has an MoNumber of 5456. The the timer redisplays the MaxMO number after 30 seconds, but it always stays at 5455. It does not find the new record. If I close the form in session #1 and reopen, the form now states the Max MO number is 5456. It seems that the timer is not clearing a buffer and does not see the new record? Any input appreciated. Thanks, -Bob -- Thompson Technology Consultants LaPorte, IN 46350 219-363-7441
