Multiple Records from a DLookUp Command - Microsoft Access

[LD527]

Hello, 

 Is it possible to get multiple records (that are different from each other) using a Dlookup command in Microsoft Access.  Whenever I use the command on a specified domain it only grabs the first record and continues to use that record in all of the other rows?  

Thank you in advance

[#2]

Dlookup is designed that way. If you want multiple, use a Recordset object.

[#3]

Thanks Tom I will try that!