Auto update a field based on another field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form with the controls name VendorID and VendorName. My question
is, how do I make the VendorName update automatically after you enter the
VendorID? What is the function that I should use? Both controls reference a
query that references a master vendor list.

Once you type in the vendor id on the form, I want the vendorname to appear.
Please help...thanks!
 
Jess said:
I have a form with the controls name VendorID and VendorName. My
question is, how do I make the VendorName update automatically after
you enter the VendorID? What is the function that I should use?
Both controls reference a query that references a master vendor list.

Once you type in the vendor id on the form, I want the vendorname to
appear. Please help...thanks!
Click to expand...

The relational way and usually the best way is to establish a relationship
between the table you want to contain the Vendor ID and the Vendor table.
Base all your forms and reports on this query and you get what you want.
 
Hi Mike,
There is a relation between the tables. The form is based on the
information in a table. In the form, if I type in vendor #1000, for
instance, I want the next field on the form, which is VendorName, to auto
update the vendor name based on the vendor ID. Does this make sense? I hope
that I am explaining it right.
 
Jess said:
Hi Mike,
There is a relation between the tables. The form is based on the
information in a table. In the form, if I type in vendor #1000, for
instance, I want the next field on the form, which is VendorName, to
auto update the vendor name based on the vendor ID. Does this make
sense? I hope that I am explaining it right.
Click to expand...
If you have the realtionship then build a query with teh vendorID as a
foreign key and the name of the vendor from the vendor table.

There is a *HUGE* amount of help and many, many examples of this available
to you with the help button, the templates you can build, and the Northwind
Database.
 
Where is the Northwind database? In addition, I tried using the help button.
Maybe I am not fully explaining my concern.
 
Mike,
I created the query and worked like a charm....I knew there was a simple
solution! Now I will add other information from a different query to this -
I can't believe that I have been stumped with question for almost 24
hours....THANK YOU!
 
northwind comes with the samples you received and is on the CD unless you
said to install it.
 
Back
Top