Can a Dlookup return multiple records


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
 
Ad

Advertisements

Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top