R
Ray C
I have a Table containing Suppliers Information and the two fields I am
interested in are "SupplierID" and "SupplierName",
I have a Customer Table that contains the "SupplierID".
I have a Form that is based on the Customer Table.
On that form, I can easily pick and display the "SupplierID" because that
info is held in that particular Table.
What I want to do is to display the "SupplierID" from the info held in the
Customer Table but I want to use that ID Number to look up the "SupplierID"
held in the Supplier Table and display "SupplierName" info associated with
that "SupplierID".
I can do this in a Combo Box by setting the "RowSource" but I dont know how
to do it with a Text Box.
Can anyone help Please?
Thanks RayC
interested in are "SupplierID" and "SupplierName",
I have a Customer Table that contains the "SupplierID".
I have a Form that is based on the Customer Table.
On that form, I can easily pick and display the "SupplierID" because that
info is held in that particular Table.
What I want to do is to display the "SupplierID" from the info held in the
Customer Table but I want to use that ID Number to look up the "SupplierID"
held in the Supplier Table and display "SupplierName" info associated with
that "SupplierID".
I can do this in a Combo Box by setting the "RowSource" but I dont know how
to do it with a Text Box.
Can anyone help Please?
Thanks RayC