It is just my opinion but I prefer to notify a user as soon as they make a
mistake. My preference would be to have verification in the BeforeUpdate
event of both controls and just check for missing entries in the BeforeUpdate
event of the form. Just my $0.02.

ridgerunner wrote:
Even if I want them to see the error before the form is complete?

NO! It should be in the form's BeforeUpdate event, not the BeforeUpdate
event of the individual controls.
[quoted text clipped - 227 lines]

End Sub

--
RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200805/1