DLookup to show multiple records on continuous form
Hi,
i am using the dlookup function in a text box and its giving me a one value. Can someone help me to modify the function which would give the result as multiple values.
The DLookup() function returns one value from a single field even if more than one record satisfies the criteria. If no record satisfies the criteria, or if the domain contains no records, DLookup() returns a Null.
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
From Microsoft's website (http://support.microsoft.com/kb/208786):