Difficult question

[SBM]

It's a difficult question because I'm not sure how to explain it ! Hopefully the answer is simple.

I have a form. On the form is a line. The angle of the line is altered depending on a value in a table. This gives the effect of a gauge (when a scale is added behind the line). In order for it to look a bit more professional I have included an expression with a do until loop with a pause which increments the angle by a few degrees until the final value is reached. When I switch from design view to form view this works perfectly.

However, when I open the form via an autoexec (or anyother way for that matter, the form opens with the line already in the final position. The user doesn't get to see the moving pointer. I've tried putting the expression in OnOpen, OnLoad, On Activate, OnCurrent but none of them work.

Can anyone help ?

 

[Fear Naught]

You probably need to reset the value of the variable in the "do until loop" or at least determine the value when the form loads. You don't say where that is coming from but it sounds as if the form is picking up the maximum value and not the minimum and then of course not incrementing through the loop.

I would add a temporary msgbox that displays the variable value as it progresses through the loop.

HTH