Is there any way that I can make sure the codes related to 2 different fields on my loan form are only activated or triggered when the form is open in Find mode, and not other modes? I included an embedded macro so the form opens in Find mode. Users can enter document and employee ID numbers in either one of those 2 fields and search for records. Based on the numbers, the codes prompt users with various msgs.
But now that also happens when users are moved to next level to for instance add a new record. In that mode, msgs are not relevant. But I can't stop them. I was told that I need to use the codes under Before Update Event. I tried that, and also On Click, After Update, On Change ... The msg boxes doesn't work unless I have the codes under On Enter Event. And it still shows the msgs in other form modes. Not sure what to do!