Hi Grace,
My name is Dennis Schmidt. Thank you for using the Microsoft Newsgroups.
You could create a function that you called on the BeforeUpdate event of
the form which evaluated your control and would not allow an update when
necessary. Something like the following would be a good starting point:
If Me!CallStatus = "Closed" and Me!ClosedBy = "" then
DoCmd.CancelEvent
MsgBox "ClosedBy requires an entry"
Me!ClosedBy.SetFocus
End If
I hope this helps! If you have additional questions on this topic, please
reply to this posting.
Need quick answers to questions like these? The Microsoft Knowledge Base
provides a wealth of information that you can use to troubleshoot a problem
or answer a question! It's located at
http://support.microsoft.com/support/c.asp?M=F>.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2001 Microsoft Corporation. All rights
reserved.
Regards,
Dennis Schmidt
Microsoft Support