It's still not clear to me what you mean by 'dynamic'. I showed in post 10 how to make the expression dynamic for the search criteria.
What DAO's Are Not Dynamic?
VIP
Windows 10 
Access 2010 32bit
It's still not clear to me what you mean by 'dynamic'. I showed in post 10 how to make the expression dynamic for the search criteria.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Who is John Galt?
Windows XP Access 2007
You showed how to make the value dynamic. OP wants the object names themselves to be dynamic. If they go the the Nav pane and rename a table, they want the table name in the DLookup to change along with it.
VIP
Windows 10 Access 2010 32bit
I wonder if they really do need that. In post 4 they said "Experimenting trying to learn." My impression was that they changed table name just trying to figure out why DLookup was not working. The reason it didn't work was incomplete expression.
AutoCorrect will not make the DLookup dynamic.
But since thread is marked Solved, something in these responses resolved issue, just not sure what.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Posting Permissions
Reply With Quote