Auto update a field based on another field

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!
 
M

Mike Painter

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!

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.
 
G

Guest

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.
 
M

Mike Painter

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.
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.
 
G

Guest

Where is the Northwind database? In addition, I tried using the help button.
Maybe I am not fully explaining my concern.
 
G

Guest

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!
 
M

Mike Painter

northwind comes with the samples you received and is on the CD unless you
said to install it.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top