Conditional Macro Problem

[Kerry]

I have a simple macro that isn't working properly

if A then msgbox
if A and B then goto next record
if C then goto next record

The problem is - if A and B also apply to the next record, it skips it and
doesn't stop until it finds a record that doesn't meet that condition. Is
there a way to fix this to make it stop at the next record even if A and B
are true?

 

[KARL DEWEY]

Insert a row below your 'if A and B then goto next record' and in the
condition put '...' without quotes. Use Stop Macro as action.

If condition is true the macro will stop and not perform the next step.

 

[KARL DEWEY]

I did not try it first -- use the below.

DateValue(DateAdd("h",-3,Now()))