Access DB shuts down on click of a textbox

[Datament]

Hello All,

How can I resolve the issue of a database shutting down after a user clicks on a particular control.



Everything works fine in the db, user can tab to and click on all the textboxxes without any issue, but once a user tabs to or clicks on "Payment" textbox the db shuts down.

[CJ_London]

Is your db split with the back end on a server and each user has their own copy of the front end? If not then the form may be corrupted. Or perhaps the control is running code causing the app to close

[Datament]

Yes, db is split and each user has a copy of the front end.

[Datament]

Yes, db is split and each user has a copy of the front end.

[CJ_London]

so no comment on whether you have any code executing when the control is clicked?

If you do - show the code

With so little information provided, all I can suggest is recreate the form, or better create a new db front end, import all objects except the form in question then recreate the form from scratch

[dblife]

I am not sure how much you know about how to use the Access form designer so I will go for the obvious of how to troubleshoot this.
Open the form in design mode.
Click on the control or field that seems to be be causing the issue.
Press f4 on your keyboard and the Properties panel should open.
Go to the events tab in the properties and make sure there is no code in any of the 'On Click' or 'On Focus' fields etc.
If there is an entry in any events field, click on the ... at the side and you will see the VBA code for that event.
If you don't understand what that code is, post it here and we might be able to help.
If all the fields are empty, there could still be rogue code happening in the form's 'On Load' event, you will have to check the main form's VBA code.

[Missinglinq]

All good suggestions...but, but Controls do get corrupted, as well as Forms, and I think the simplest thing to try, first, would be to delete the offending control, then recreate it. IF that works, remember to replace all of your users Frontends!

Linq ;0)>