Combo Box Problem

[wjoc1]

I have a Combo Box on a 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

 

[lois chipperfie]

www.ageesw.com/access.htm Try doing the tutorial from this site. I think It will help. I was referred to it by another "user" and it helped. Lois