I have two tables linked in a one to many relation for referential integrity. Using a form, I try to enter an id in the many table that does not exist in the one table. Naturally Access give me an error message just as I expect it to. I want to set up error handling so that when the invalid ID is entered, I display a message to the user and then as soon as they click the OK, I clear out the field in the form and make it ready for fresh data entry. Manually, right now, I hit the OK on the error trap msgbox that I've set up, then I have to clear the access message saying that the record can't be added and then I have to hit the ESC twice to clear the text box. I want to get just the one message that I generate and then clear the text box automatically.
