Using Condition in Stop Macro

[MikeWaring]

I hope someone can help me - I'm trying to write a macro that stops or runs depending on the value of a certain field in the related form. This Conditional field ("ORDER_TOTAL") in question is a calculated total value of all the value of the records in the form.



In detail, the form contains a list of all products that require to be ordered from a supplier. If the "ORDER_TOTAL" value (ie the total of the value of all the lines) is below £1000, the macro will stop but if the "ORDER_TOTAL" value is above £1000, the macro will send a csv file of the form contents.

I've written many Stop macros using the IsNull function without any problems, but this one has me stumped.

I'm clearly missing something simple here..

Here's the condition I've tried to use

 ([Forms]![FLAG UP LOW STOCK - AMTECH]![Order_Total])<1000

, but the macro only runs the "Stop" action. I've also tried the ">1000" but it still only runs the Stop actions.

I'm wondering if the problem is to do with the fact that the control field is a calculated one so as such isn't really part of the form contents.
All ideas would be welcome. I have no clue about VBA so I need to do this with a macro.
Thanks in advance,
Mike

[June7]

Code should be able to reference control that has calculated value.

I use only VBA but can sometimes debug macros, if you provide the file. Follow instructions at bottom of my post.

[MikeWaring]

Hi, thanks for the quick response. In the meantime I've been trying different things and what appears to be happening is that if the form is already open and displaying on the screen the macro runs as it should. But if I let the macro open the form, the macro doesn't work.

What is more puzzling is that if I call a macro to open the form as the first action of the stop macro (even before the "Open Form" part of the stop macro), the stop macro still doesn't work. I've even tried to add "Repaint" action, but it still doesn't work.

So I'm completely baffled. The macro doesn't actually error out, it just seems to default to the "Stop" condition if the form isn't already open. When it is, the macro performs both conditions properly, depending on the £ value in that control field.