using .OldValue gives error 3251

[jflachman]

When I execute the following code in the [tt]BeforeUpdate[/tt] event I get [tt]Error 3251 "Operation is not supported for this type of object"[/tt]

Here is the code:[tt]
If ((Me![Plan date] <> Me![Plan date].OldValue) Then
{insert code here}
End If[/tt]

When I try to look at the value of the [tt].OldValue [/tt]property during runtime, I get the error message too, so I know that is the problem.

I also know that [tt][Plan date][/tt] is a control of type [tt]acTextBox[/tt] and the field is bound to a table.

Any ideas?

Jonathan
________________________________________
It is not fair to ask of others what you are unwilling to do yourself.
-Eleanor Roosevelt

 

[PaulBricker]

What version are you using. I just tried it in A2000 just the way you have it and it ran fine.

Paul

 

[jflachman]

I am using 2002... it does work in other modules but not here. I have no idea why. Jonathan
________________________________________
It is not fair to ask of others what you are unwilling to do yourself.
-Eleanor Roosevelt