Strange issue with my access application. I have a backend with SQL server express 2008 r2, frontend Access 2010. I made an error checking procedure for when one of our offices disconnecting from our central server so that it will relink, then do an insert into the right table so they do not have to retype the information due to a disconnect. The Sql insert works fine, however if I do not enter a character into a particular text field it crashes and restarts the application. When it restarts the inserted portion is fine. If I enter a character into the text field it doesnt crash, it does the proper code, which closes the form and then opens the form. If I put a space character then delete it from the textbox, it works fine, if I enter anything into the field it works. Put nothing in yeilds a crash. I have compacted and repaired several times, I even debugged for 3 hours. Nothing looks wrong until it exits my form_errror sub-routine. Then it just crashes, with no error codes or anything.
Any help would be super awesome! My last problem got solved very quickly. Is there some sort of error trapping I can do?
Let me know!