DLookup next record

M

Mike

HELP! I have a form that is based off of a query. I am trying to pull
information from another table to incorporate in the form. I can't add the
table to the query because I can't add/edit records then. I used the DLookup
command and it works,,, except,,, the only record I can get is the first
record. Is there anyway that I can "scroll" the those records? I have tried
combo boxs and I can't get them to do anything. The form and query is
designed to add vendor information and values to complete a Purchase Order.
The "other" table information I am trying to pull is the company's name,
address etc. Pending on the PO, I will need 1 of 5 different companies
information. Any suggestions?

Thanks
Mike P
 
G

George Nicholson

Create a Vendor subform and add it to your form using VendorID as the
Parent/Child linking field.
Then, the VendorID in your PO record will drive the display of that Vendor's
information in the subform.

HTH,
 
Top