DLOOKUP Syntax In VBA Module - Access Developers


	Back to Access Developers Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

DLOOKUP Syntax In VBA Module

Justene Justene

4 years ago

Hi team.

I have an large query that I need to continue over multiple lines and I am having trouble with the correct syntax for the DLookups that form part of this query.

The original SQL is:
DLookUp("Frequency","tblMeterCharges","RetailerCode='TODD'")
I have tried changing it to:
DLookUp('Frequency','tblMeterCharges','RetailerCode="TODD"') in the VBA Module but that doesn't work.
Can you please help me out with the correct syntax here?

	Kevin Robertson @Reply 4 years ago
Have you set the DLookup to a Variable or a field on your form? `FieldName = DLookup("Field", "Domain", "Criteria")` You will also need the NZ Function in the event a Null value is returned.

	Kevin Yip @Reply 4 years ago
The syntax is correct in both cases, so the problem lies elsewhere. The error messages you get from queries are often not helpful (e.g. Incorrect syntax near ','), and they don't always point you to the right place. The problem is likely somewhere else in the query.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Developers.

Next Unseen

New Feature: Comment Live View