E
Eric
Hi! I have a form which is linked to a table
called "Quote System" that stores the information entered
on the form. At the top of the form there are fields
labeled "Company Name" which is a dropdown box, "Contact"
also a dropdown box, "Phone" a textbox, and "Fax" also a
textbox. The drop down box for "Company Name" gets its
value from a table called "Master Info". I also have a
table called "Contacts" that has all of the names,
phone#s, and fax#s for the corresponding companies. Most
of our customers have multiple of each of these fields
for one location. The two tables, "Master Info"
and "Contacts" are relationshipped through company name.
What I would like to have happen is when a user accesses
the first drop down to choose a "Company Name"
the "Contact" drop down has its value limited to only
those contacts for that company. After a contact is
chosen, I would like the Textboxes for Phone & Fax to
automatically be filled in. Can this be done? Also, how
would I set up those four boxes to be used to add info to
those 2 tables? I just started using Access and while I
am pretty familiar with VB for Excel, unfortunately, the
VB for Access doesn't seem to be the same. Any help with
this would be greatly appreciated. Thanks in advance!
Eric
called "Quote System" that stores the information entered
on the form. At the top of the form there are fields
labeled "Company Name" which is a dropdown box, "Contact"
also a dropdown box, "Phone" a textbox, and "Fax" also a
textbox. The drop down box for "Company Name" gets its
value from a table called "Master Info". I also have a
table called "Contacts" that has all of the names,
phone#s, and fax#s for the corresponding companies. Most
of our customers have multiple of each of these fields
for one location. The two tables, "Master Info"
and "Contacts" are relationshipped through company name.
What I would like to have happen is when a user accesses
the first drop down to choose a "Company Name"
the "Contact" drop down has its value limited to only
those contacts for that company. After a contact is
chosen, I would like the Textboxes for Phone & Fax to
automatically be filled in. Can this be done? Also, how
would I set up those four boxes to be used to add info to
those 2 tables? I just started using Access and while I
am pretty familiar with VB for Excel, unfortunately, the
VB for Access doesn't seem to be the same. Any help with
this would be greatly appreciated. Thanks in advance!
Eric