• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 564
  • Last Modified:

DTPicker losing Control Source

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.
  • 2
1 Solution
Well, if you just want a bandaid, write a little script that fires off say every 30 minutes or so.  The script would simply tell the control what its control source is.  (I did this once with a combox box.  Required a form to be open, as I tied it to the form's timer control, but you can use TIME to evaluate how many seconds have passed, and after , say 5000 seconds, tell the control what its control source is again.)  You wouldn't get an error, even if it already had the right control source and you told it the same thing again.  
lmerrellAuthor Commented:
That could be of some temporary help, doug.  Although, I would probably put the Control Source update in the Current event of the form which would guarantee its update more often.  But, I would really like to figure out what is causing this behavior in the first place.

I will post you an additional question with points for your bandaid solution later.  I'll post a link to the Q here.
lmerrellAuthor Commented:
Well, I haven't had any other input and the updating of the Control Source in the Current event appears to be working quite well so the points are yours Doug.

Thanks for the input!

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now