dlookup fields not refreshing all of a sudden
Posted on 2014-03-31
I have been using the same database for years that uses a subform that has a series of fields populated by the dlookup command. I am using Windows 7 and Office 2010. Since last week in every one of these databases you need to click field by field for the data to appear. I have made no changes at all to the database. I am assuming a Microsoft upgrade had something to do with this.
I found out I can use the F9 key which immediately fixes this issue. How can I fix this programatically? I have tried the refresh and repaint method with no success. What needs to get refreshed? The main form,the sub form, each dlookup field? Thanks for any insight.