I have an Access 97 app which uses the MS DTPicker control for updating a Date/Time field. The DTPicker control is bound to a field named EffectiveDate. The database resides on an admittedly inadequate server and is used daily by 6 users.
Occasionally (maybe once every couple of months but recently much more frequently) the DTPicker control loses its Control Source property value. It is suddenly no longer bound to the EffectiveDate field. <eerie music plays in background>
Any ideas? I will gladly provide additional info upon request.