I have a form that contains multiple records. I can delete each entry successfully without any Access harrassment. However, when I select the last record and either hit the delete key or click on my delete record button focus remains on the required field and any attempts to go anywhere else on the form render the message "The field xxx can't contain a Null value because the required property for this field is set to True. Enter a value in this field." I do want this field to be required to avoid adding blank records to the database. Also, I purposely want focus on the required field to make sure the user enters data. It's like I'm in a delete mode and can't get out without getting that message. I have tried gotorecord to go to another record. I have tried sendkeys to send an escape to break out. All this with very little success. If anybody has a clue, please let me know. Thanks.
