By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,708 Members | 2,095 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,708 IT Pros & Developers. It's quick & easy.

MS Access lookup fields not refreshing automatically

P: 1
I have an Access 2010 database that uses a number of forms / reports most of which have DLOOKUP functions. On many different computers / laptops the forms work perfectly, but on one laptop, a very new (<6months old) Lenovo thinkpad running Windows 7 professional, every field on every form or report that uses DLOOKUP, on opening shows no data until the F9 (refresh) key is pressed or the field is entered. All the lookups then display correctly until the form is reloaded or a report is scrolled when, once again, the DLOOKUPS are blank and need to be manually refreshed. There is also a constant "calculating..." indicator on the bottom left of the Access screen, although the application is perfectly functional otherwise.

This only happens on the one laptop and as far as I can tell there are no differences in configuration on the affected machine. Another relevant point is that about two months ago the forms worked perfectly on this same laptop.

Is there an Access (or other) setting, hidden or otherwise, that could have changed to cause this?
Sep 17 '13 #1
Share this Question
Share on Google+
1 Reply

ryno du preez
P: 91
Did this masjien have any office updates installed on it ?
Mar 3 '14 #2

Post your reply

Sign in to post your reply or Sign up for a free account.