Multiple Records from a DLookUp Command - Microsoft Access

New Contributor

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 Replies
Dlookup is designed that way. If you want multiple, use a Recordset object.
Thanks Tom I will try that!