I have a form that is used for entering shipments of parts to suppliers.
The data entered on the form is written to a table called tPartsSent. On
the form, I'd like to have a way for users to select a PO from another table
(tOrders) via a dropdown list. When they select the PO, a couple of text
boxes (read-only) should populate automatically with info for reference
(e.g. vendor name, podate, etc). I'm having difficulty because the main
form is tied to the tPartsSent table and I'm trying to bind the drop-down
list to a lookup from a completely different table. That parts works as I
can see the POs from the drop-down list. Where I get lost is attaching the
results of the drop-down list selection into the read-only reference boxes.
The query for the drop-down list is:

select PONum, Vendor, PODate from tOrders order by PONum Asc;

On the form, I have a text box called Vendor and another called PODate. I
just can't seem to get them to display the appropriate values when a
selection is made from the drop-down list. Remember, the values are
strictly look-up for reference only out of tORders. They will not need to
be written to tParts. Any help would be great!

Please disregard - I did some research and found my answer...

http://support.microsoft.com/kb/319482/EN-US


<MX1> wrote