Form buttons have suddenly disabled themselves

[bsnalex]

This morning a very odd error has cropped up, that I'm hoping someone here can help with. Two buttons on a subform have suddenly disabled themselves. They should look like this:

Instead, they look like this:

Notice the magnifying glass and "X" are now greyed out. The buttons themselves are now disabled. The only VBA I have to disable the button (and it only extends to the "Search" button) is if the "Type of Contact" field is null, then disable the search.

Database is a Desktop-saved front-end, linking to a fileshare backend that all users (~ 25) are currently accessing via VPN due to the entire organisation working from home. I have not updated the front end in quite some time, so there is no update that should disabled the buttons.

Relinking my local desktop front end to a desktop-saved copy of the back-end does enable the buttons. However, there is nothing I've tried thus far that can re-enable the buttons using the file-share backend. Obviously, pushing a desktop-backend to all users is completely untenable.

There are no errors with the back-end and running both the back and front ends in decompile mode does not throw any issues. I also have compacted/repaired to no help.

If anyone can suggest anything I'd be really grateful.

 

[theDBguy]

Hi. I think to really help you figure this out, you may have to share a copy of your db. Can you post a demo version with just the problem objects included (enough to duplicate the issue)?

 

[bsnalex]

Hi. I think to really help you figure this out, you may have to share a copy of your db. Can you post a demo version with just the problem objects included (enough to duplicate the issue)?

Oof. I'll try to strip it down but the problem doesn't persist. If the table is local the problem isn't there. I'll see what I can do.

 

[theDBguy]

Oof. I'll try to strip it down but the problem doesn't persist. If the table is local the problem isn't there. I'll see what I can do.

Well, that would make it hard for us to troubleshoot then. As a last resort, maybe we can do a screen share/web conference meeting.

 

[Deleted member 147267]

That looks like a continuous form. If one command button gets disabled, all copies of that control get disabled no? I guess that doesn't explain why any particular one would get disabled. Check the property sheet in case it got changed if you're sure there is no code that sets the enabled property for the search button.