ACC2: "#Error" Running DLookup() Example in "User's Guide" (121783)
The information in this article applies to:
This article was previously published under Q121783 Novice: Requires knowledge of the user interface on single-user computers.
SYMPTOMS
Page 460 of the Microsoft Access version 2.0 "User's Guide" contains an
example of using the DLookup() function to return the contact name of the
supplier whose ID matches the value in the Supplier ID control on the
Products form. This example contains a syntax error. The example
incorrectly uses a period (.) instead of an exclamation point (!) to
reference the Supplier ID field. If you use this example, you may receive
a "#Error" message in the control on your form.
RESOLUTION
The correct syntax for the example is as follows.
NOTE: In the following example, an underscore (_) at the end of a line is
used as a line-continuation character. Remove the underscore from the end
of the line when re-creating this example.
=DLookup("[Contact Name]","[Suppliers]","[Supplier _
ID]=Forms![Products]![Supplier ID]")
STATUS
This behavior does not occur in Microsoft Access version 7.0.
REFERENCES
Microsoft Access "User's Guide," version 2.0, Chapter 18, "Using
Expressions in Forms," page 460
| Modification Type: | Major | Last Reviewed: | 6/25/2002 |
|---|
| Keywords: | kbusage KB121783 |
|---|
|