DLookup is the least preferred method as domain aggregate functions can perform slowly in queries and on forms. Try one of the other two methods. Or post your attempted DLookup() expression.
DLOOKUP in access 2007 forms to auto populate selected fields
VIP
Windows 10 
Access 2010 32bit
DLookup is the least preferred method as domain aggregate functions can perform slowly in queries and on forms. Try one of the other two methods. Or post your attempted DLookup() expression.
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.
Advanced Beginner
Windows 10 Access 2007
=DLOOKUP("[surname]","debtor details", "account number=13351/2")
VIP
Windows 10 Access 2010 32bit
Space in field name - use []. Also, the field is text type so need apostrophe delimiters.
=DLOOKUP("[surname]","debtor details", "[account number]='13351/2'")
If you want to pull dynamically based on current record:
=DLOOKUP("[surname]","debtor details", "[account number]='" & [account number] & "'")
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.
Moderator
Windows 10 Access 2010 32bit
Can you please tell us about your tables and relationships?
Auto-populate ID number field after description is selected.
Posting Permissions
Reply With Quote