Stay on current Field

[tcheck]

I have error handling code on a field (After Update) in a form that is, if a directory does not exist the user needs to create the directory. I want the user to stay on the current field and not move on until the directory is created. I tried gotorecord and several other commands but nothing is working. How can I accomplish this?


Err_MissingQuarter:
MsgBox "An error has occured, please make sure that the Year and Quarter Directory has beern added to the [J:\Sales Dept\] Reports directory"
Me.ResearchDate.Undo

[amrut]

Try with before update event.
Logic -
If DirectoryExists=False then
Cancel=True
Endif

[KathyL]

With your event procedure, add a line to set the focus to whatever field you want, like:
me.fieldname.SetFocus

Cancel could lose everything else the User entered, so think your logic through.