Hi All,
Hope the year has been good to you. I have an interesting situation and not sure why this is happening.
I have a table with 2 columns impacted by a macro. The first column is a status column and the second column is a date column.
The before update macro is setup that when the status field (which is a data validation drop down, either "open" or "closed") is set to closed, then the date column will equal Now(), else Null.
Then I created an update query on access, which takes 2 columns called "Major" and "Minor" from another table and updates the "Major" and "Minor" columns in the first table when run.
So the macro is dealing with the "Status" and "Date" columns while the Query impacts the "Major" and "Minor" columns.
Now what's intriguing is that when the update query is run, for some reason the macro seems to be triggered as well, then takes all the records with the Status as "Closed" and changes their date columns value to Now() when the update query is run?
This is strange as the update query should not be impacting the before update macro.
Does anyone know why this maybe and how I can resolve this problem? Thanks.
Kind Regards,
Raf