-------------------------------------------------------- Error Procedure Builder 2 - By Brian A. Manlove 70543,1420 -------------------------------------------------------- EPB2 is the new brother of EPB, a previous version which did not insert an error MsgBox. EPB2 will give you a generic Error MsgBox. Like EPB, EPB2 is a standard Windows Recorder macro. It quickly inserts generic error trapping with a generic Error MsgBox into any Access sub procedure. I have tried some of the "wizards" that are out there, and I think this macro works better, faster, and best of all, it won't add another megabyte or two of "maybe-it-might-work" crap on your HD. ------------------ Instructions: ------------------ Unzip EPB2 to the directory of your choice (mine is in my ACCESS directory). Launch the Windows Recorder application and open the ACC_EPB2.REC file. Get back into your Access program. Select the property you want to add code for, select the Code Builder, and after the sub procedure heading is displayed, press the "hot key(s)" to run the macro. If you do run EPB2 with some code you have already entered, you might have to cut and paste your code back into the proper position, which is usually before the "Exit_Blah_De_Dah:" line. The EPB2 macro has been pre-set to playback ONLY to MS Access. I used the CTRL/ALT/HOME "hot key" as the trigger to run EPB2 - you may want to change this to your own preferred keystroke sequence. Happy Procedure Error Trapping!!