We have a form that I need to track the producerID before it changes so we can tell the who the former producer was. I thought the BeforeUpdate would work but it gives me the producerID of the producer we are changing it to. Here is the code I am using in the field.
Private Sub Combo17_BeforeUpdate(Cancel As Integer)
[FormerProducerID] = Me![ProducerID]
End Sub
How can I get the produceID before it's changed?