DLookup no longer working on subform

D

Don Brumfield

I imported a database from Access 2000 into Access 2003 and the Dlookup function in my subforms no longer works. The syntax is correct and it has worked with no change in several versions of Access. I did not change anything.
 
J

John Vinson

I imported a database from Access 2000 into Access 2003 and the Dlookup function in my subforms no longer works. The syntax is correct and it has worked with no change in several versions of Access. I did not change anything.
Click to expand...

This appears to be the very common References bug. Open any
module in design view, or open the VBA editor by typing
Ctrl-G. Select Tools... References from the menu. One of the
..DLL files required by Access will probably be marked
MISSING. Uncheck it, recheck it, close and open Access.

If none are MISSING, check any reference; close and open
Access; then uncheck it again. This will force Access to
relink the libraries.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Report Group Footer DLookUp 0
DLookup in Continuous form 0
Form Subform DLookup 3
Adding data from a table to a subform with DLookup 1
Section and Page numbering 0
Print order of TriFold - Publisher 365 0
Incorporating the User Profile location into a document template path 1
Code not finding subforms 1

Top