I have a listbox to display all the tickets in tblTicket my department is 

working on. I have several relationships with other tables, the primary 

keys of which are stored tblTicket. 



The listbox, now, displays those primary keys but not the information they 

refer to, no matter what type of query I apply as RowSource. Is there a 

way to adapt the listbox to display the information in stead of the 

primary keys.



Peter Wellens

Peter,

Have you tried a combo box instead?  That way you can use the column count 

to list the columns.  Also you can adjust the columns widths so that the 

primary key will not show. Anyway just a thought.

Good luck

Terry--



> I have a listbox to display all the tickets in tblTicket my department 

is 

> working on. I have several relationships with other tables, the primary 

> keys of which are stored tblTicket. 

> 

> The listbox, now, displays those primary keys but not the information 

they 

> refer to, no matter what type of query I apply as RowSource. Is there a 

> way to adapt the listbox to display the information in stead of the 

> primary keys.

> 

> Peter Wellens