Yeah, problem occurs after using for quite a while.Isn't that backwards, according to thread title?
Spending hours and finding out how to overcome the problem, but another one emerges.check and test
upload your db.
It's all OK when I choose Yes, it changes to the data I pointed.test it again. select a combo will immediately save the record so you need to add a "delete" button.
i tested many times and it is not changing.But when I choose No, it changes also
Try my move, it's simple:i tested many times and it is not changing.
If Me.SomeFIeld & "" = "" Then
Msgbox "Some Field is required.", vbOKOnly
Me.SomeField.Setfocus
Cancel = True
Exit Sub
End If
If Me.SomeDate > Date() Then
Msgbox "Some Date must be <= Today's date.", vbOKOnly
Me.SomeDate.SetFocus
Cancel = True
Exit Sub
End If
Tested, it worked perfectly!ok test again and make your move same as in post #29