I have a Combo Box on a continuous form which allows me to select from a list of values that are stored in the field of a table.
When I select a particular value I want the rest of the information from that record in the table to be dispalyed also but how do I set this association between the controls on the form.
An example of the table might be:
Code___Description
143___Some description
156___Another description
Now I have a combo box on the form which displays the values from the field Code and when I select a particular value I want the relevant description to be displayed on the form also. How do I do this?
Liam
When I select a particular value I want the rest of the information from that record in the table to be dispalyed also but how do I set this association between the controls on the form.
An example of the table might be:
Code___Description
143___Some description
156___Another description
Now I have a combo box on the form which displays the values from the field Code and when I select a particular value I want the relevant description to be displayed on the form also. How do I do this?
Liam