Can a Dlookup return multiple records

[Alex]

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

 

[Terry Kreft]

No, the way to do this would be a combo box or a list box.

 

[Duane Hookom]

There is a generic concatenate function at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane that
could possibly be used like:
=Concatente("SELECT SUPPNME FROM PO WHERE PARTNO =" &
Forms![NewPartInputfrm].RefPart)
If PARTNO is text, try:
=Concatente("SELECT SUPPNME FROM PO WHERE PARTNO =""" &
Forms![NewPartInputfrm].RefPart & """")