Syntax question

John Cutlip 1 Reputation point

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.

Microsoft 365
Microsoft 365
Formerly Office 365, is a line of subscription services offered by Microsoft which adds to and includes the Microsoft Office product line.
145 questions
A set of technologies in the .NET Framework for building web applications and XML web services.
1,190 questions
No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Michael Taylor 37,946 Reputation points

    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.

    No comments