Update a field based on another field change 1

[OrbeaRider66]

Okay, I'm really stuck here. I'm new to using VBA but am familiar with how it all works. My problem is that I just can't seem to figure out how to make everything work and, until I can get some sort of VBA training, I really need help.

I have a table (tblIncident) with two fields: status and closed_by. I'm trying to use VBA to set closed_by to "Trent" whenever status changes to 2. I've searched all over the internet for help on how to do this but nothing I've found works.

Any suggestions? I'd appreciate any help I can get.

Thanks!

 

[BDCarrillo]

On the "AfterUpdate" of whatever control you use to enter the status change, add code to make the change.

Ex:

If status=2 then
closed_by="Trent" (or whatever control/list/query)
MsgBox("Closed_By has been updated.")
else
endif

 

[OrbeaRider66]

BD ... thank you so much. That was exactly what I was looking for. I really appreciate your help and I can move forward with this again!

JT