Can a Dlookup return multiple records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a text field on my form called SupplierName. I am using setvalue in
another field to set the value of the SupplierName:
DLookUp("SUPPNME","PO","[PARTNO]=Forms![NewPartInputfrm].RefPart")

It works fine except that there will be many instances where there is more
than one matching PARTNO int the PO table. Is there a way I can list all the
SupplierName results from the PO table in my text field? I know I could use
a combo box, but was hoping dlookup in a text box. Thanks much -

Alex
 
Back
Top