OldValue Not Working

[smdemo]

I have a form where I had a field being reset to the original value if other criteria was not met. After a few updates were made to the database this code is no longer working. I am getting an "Operation is not supported for this type of object." error.

If I save the record upon entering the field, making my changes and saving again I do not get the error though.

I have linked it to the Me.TaskStatus.Value = Me.TaskStatus.OldValue in my code but have no idea why it worked before and no longer does.

Does anyone know how to get this to work again?

 

[TheAceMan1]

How are ya smdemo . . .

Call VBA's immediate window (Ctrl + G). Enter [blue]OldValue[/blue]. Makesure the cursor is on the word and hit [blue]F1[/blue] . . .

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]