Combo boxes

[Guest]

I have a form that contains a combo box for companies and text fields for the
details pertaining to the companies e.g. Address, Telephone No etc.
What is the best way of refreshing the data displayed on the form when you
select different companies within the combo box?

 

[Naresh Nichani]

Take a look at this
http://www.techonthenet.com/access/comboboxes/linked_combos.php

Regards,

Naresh Nichani
Microsoft Access MVP

 

[Guest]

Hi,
Thanks for responding.
The first field on my form is a combo box that contains a list of company
names.
All the other fields on the form are text fields for Address, Telephone
number etc etc.
How do I get the data to change when I select different company names in the
combo box?

 

[Guest]

Hi tezza,

Take a look at the Orders form in the sample Northwind database. This
includes a combo box named "CustomerID" with a control source of the same
name. The control source is the foreign key field where you store the value
selected by the user. Open the form in design view. If necessary, click on
View > Properties to display the properties dialog. Select the combo box. You
should see the name of the combo box in the blue title bar of the properties
dialog. Select the Event tab. Click into the After Update event procedure.
Click on the build button (3 dots) that becomes visible. This will take you
to the event procedure in question. Alternatively, since, there isn't much
code behind this form, you can click on View > Code and easily find the
AfterUpdate event procedure.



Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

:

Hi,
Thanks for responding.
The first field on my form is a combo box that contains a list of company
names.
All the other fields on the form are text fields for Address, Telephone
number etc etc.
How do I get the data to change when I select different company names in the
combo box?