Syntax question

Question

Right now, I have a macro set up in Microsoft Access that runs successfully when I click the field, but I only want it to run if the field has a value of 1000.00 or greater.
I'm thinking I need to create a "Where Condition" in my macro, have tried everything but just can't get the syntax correct for this.

Answer 1

I assume you are handling the click event on the cell. In that case the click event will always fire. What you should do is modify your macro to check the value and if it doesn't meet your requirements then exit the macro.