I have a field called "Bad Pc Part" which is a listbox. THe problem is I want it to display the contents of 3 other fields from another table.

I created a query for the Bad Pc Part field but the problem is it only displays the information in the first field of the table. It doesnt show the contents of the other columns. I need it to do this.

Please Advise3.

A listbox can show many fields. So can a combo but only in its drop down state. Once you select an item only the first field remains visible. There are many methods to show the others. Look for some sample databases in the samples forum. I don't have a link handy. I posted a db that showed three methods.