E
Eric
Hello! I am trying to set up a form that utilizes
information from 3-4 different tables. All of the fields
in the form are supposed to be automatically updated from
entering information into a combo box. I have a Combo box
at the top which is labled "Company", Under that
is "Contact", (info for this box is stored in a seperate
table.) The information for contact should be displayed
through a combo-box interface that only brings up the
contacts available for that Company. Two other textboxes
(Phone, Fax) should be automatically filled in upon
entering a Contact. I did this in Excel and it was very
easy, except I could only store one Contact, Phone, Fax
for every Company. Unfortunately, I have many contacts
for the same business. I don't know very much about
Access at all and so far, I've noticed that the VB
programming is not like Excel at all. What would be the
best way to go about doing this? Any help would be
greatly appreciated. If anyone knows whether there is an
online walkthrough for this sort of thing, that would be
great! Thanks again!
Eric
information from 3-4 different tables. All of the fields
in the form are supposed to be automatically updated from
entering information into a combo box. I have a Combo box
at the top which is labled "Company", Under that
is "Contact", (info for this box is stored in a seperate
table.) The information for contact should be displayed
through a combo-box interface that only brings up the
contacts available for that Company. Two other textboxes
(Phone, Fax) should be automatically filled in upon
entering a Contact. I did this in Excel and it was very
easy, except I could only store one Contact, Phone, Fax
for every Company. Unfortunately, I have many contacts
for the same business. I don't know very much about
Access at all and so far, I've noticed that the VB
programming is not like Excel at all. What would be the
best way to go about doing this? Any help would be
greatly appreciated. If anyone knows whether there is an
online walkthrough for this sort of thing, that would be
great! Thanks again!
Eric