Sorry about that. I have a full posting two up on this list, by the subject
line.
I have created a form using two tables, Order List and the other Invoice
List. I use two field from the Order List, PO and Vendor. The rest of the
fields are populated with data right off the invoice. I want to make sure
the correct vendor and po match the invoice so I created a combo box to look
up and display the orders PO and Vendor. I then have the Vendor stored in
the Invoice List table. It works fine except the when I enter certain PO
numbers a different PO number appears after I click enter or tab. I found
that Vendor of that order is the same as the Vendor of previous orders, it
displays the PO number of the FIRST ORDER PLACED WITH THAT VENDOR. SO even
if thought DOES bring up the correct vendor I need to re-enter the Correct PO
number.
Lin
