Controls w/ DLookup ControlSource endlessly recalculating in Windows 8 (Access 2003).
Posted on 2013-01-10
I know that Access 2003 is not supposed to work with Windows 8 but I have found it does just fine with this one exception.
If I have a TextBox control with "=DLookup..." as its ControlSource, it just keeps recalculating endlessly when I open the form. This never happened in Windows 7.
Any ideas on what is happening here? The form where it does this is a continuous form so there are multiple instances of the control. As it recalculates the control appears to flash.
Thanks in advance.