Hi, I have the following code in my firms before update event:
If isnull(me.date) then
Msgbox "date field cannot be blank"
The code works ie when the date field is left blank the user is prompted with the message box. The problem is after you click on ok on the defined error to accept it, you then get a ms access error: "you can't go to the specified record".
How can I get access not to display this message?