Need help troubleshooting

[JCShort]

Randomly, yet regularly, my form won't open properly. I receive a 'syntax error in expression query' for the input mask I use for all of my date fields. When the error occurs, one or more of my subforms won't open.

I've found that the error goes away when I delete the sorting criteria on the parent form properties. However, the sorting criteria 'magically' reappears every few days and I receive the same syntax error. What am I missing that the properties won't stay deleted? I do not have any sorting coded in VBA.

Will the form properties repopulate themselves if a member of my staff manually sorts the form by right-clicking in one of the text boxes?

Thanks
J

 

[Rabbie]

Is it possible for you to post your DB so we can take a closer look at it.

 

[CyberLynx]

This sort of thing is very common when Form properties are changed during Run-Time and then the Form is placed into Design View (oops). When the Form is started again, you will get a "Do you want to save Changes" message. If Yes is selected, then chances are that if code had changed properties before the Form was put into Design View then when the Form is saved and run again those coded changes will stick.

Ensure Users do not have access to the Design View option within the Pop up menu or any other means.

Code changes to properties within a Form are lost when the Form is closed.

.

 

[JCShort]

Thanks CyberLynx. I've removed Design view options from the users. {fingers crossed}

Rabbie, if the error comes back, I'll post the DB. Thanks for the offer!