Going back to the old value

[yhgtbfk]

I want to do the following:

If user enters dumb value Then

Go back to the old value

Else

Do some code

End If

For example...

Imagine there is a text field called city and currently has the city name

If the user enters something, I want it to revert back to the name of the city that was there before the user entered the data.

 

[WayneRyan]

y,

Use the AfterUpdate event and if the test fails, then just set:

Me.MyField = Me.MyField.OldValue

Wayne

 

[WayneRyan]

y,

One more thought. .OldValue is only available for bound fields.

Wayne

 

[yhgtbfk]

That worked perfectly.

Thank you