Fault Log

[M_Mike]

I am creating a database to log faults with a system. I have created a form which allows the user to enter the details of the fault. But I also want to be able to display information about the location of the fault on the same form when a selection is made in the combo box.

For example I have created a combo box which allows the user to select the location of the fault eg. location1 and its address. I then want the text boxes on the form to display information such a telephone number of the location selected in the combo box. This information is taken from a seperate table.

Any help would be great. Thanks

 

[M_Mike]

I have created the combo box and it shows the values I want from the other table, but when I try to select on of the enteries, nothing happens and access just beebs.

Could anyone suggest what might cause this.