Using Combo Box as Index

[tgwacker]

I have created a form containing contact information. The form is in 2 parts. Part 1 contains general information about the company, i.e. Company Name, Address, etc. Part 2 is a sub-form that contain data about contacts at the company, i.e. Person's Name, Title, Phone Number. The sub-form has a vertical scroll bar in order to see more names than will fit in the form window. This is working. As I navigate using the Access Navigation buttons at the bottom, the Company's information changes and the sub-form shows the people for that company.



I now want to create an index on the form so that the user can select the company's name and have the data for the selected company appear. I created a new form that contains a combo box containing the names of all the companies. I then included the form described above as a sub-form. I then used the company's name to tie this new form with its sub-form. When I navigate using the Access Navigation button at the bottom, the data changes in all fields properly. However, I have 2 issues:
1 - When I select a new company from the combo box, the value in the combo box changes, but the data in the sub-forms do not.
2 - The scroll bar for the list of people and phone numbers does not work. For example, it tells me that there are 4 contacts, shows the first 3, shows the scroll bar, but the scroll bar does not move so that I can see the last line.
This form is to be used for display only, without allowing anyone to update the data.

I have the following tables involved:
1. Name table - contains only the company name, used for the combo box
2. Company table - contains company name, address, etc, This is read using a query, which combines some fields for display purposes such as city, state, and zip code.
3. Contact table - contains contact name, position, phone number.

[Ruegen]

I have created a form containing contact information. The form is in 2 parts. Part 1 contains general information about the company, i.e. Company Name, Address, etc. Part 2 is a sub-form that contain data about contacts at the company, i.e. Person's Name, Title, Phone Number. The sub-form has a vertical scroll bar in order to see more names than will fit in the form window. This is working. As I navigate using the Access Navigation buttons at the bottom, the Company's information changes and the sub-form shows the people for that company.

I now want to create an index on the form so that the user can select the company's name and have the data for the selected company appear. I created a new form that contains a combo box containing the names of all the companies. I then included the form described above as a sub-form. I then used the company's name to tie this new form with its sub-form. When I navigate using the Access Navigation button at the bottom, the data changes in all fields properly. However, I have 2 issues:
1 - When I select a new company from the combo box, the value in the combo box changes, but the data in the sub-forms do not.
2 - The scroll bar for the list of people and phone numbers does not work. For example, it tells me that there are 4 contacts, shows the first 3, shows the scroll bar, but the scroll bar does not move so that I can see the last line.
This form is to be used for display only, without allowing anyone to update the data.

I have the following tables involved:
1. Name table - contains only the company name, used for the combo box
2. Company table - contains company name, address, etc, This is read using a query, which combines some fields for display purposes such as city, state, and zip code.
3. Contact table - contains contact name, position, phone number.

do you have after updates on the combo boxes - do they requery the lists/subforms?