List box question

[Guest]

I have a table, 'ConfRooms' with two fields, RoomID and RoomName. In the
field properties> Look up, I created a combo box so the name of the room
would show up in my forms instead of the RoomID number. I have a query based
list box using this field. In the query view window, it shows the room,
however, in the list box it shows the RoomID number. What am I doing wrong?
Thanks
Ron

 

[Guest]

Be sure to set the 'ColumnCount' property of your listbox to 2 and set the
'ColumnWidths' property to '0;1' to hide the first column.

 

[Guest]

I am using RoomID in my 'Orders' table. I checked the combo. It is correct.
Also, the name shows up under RoomID both in my 'Orders' table and in the
list box query.
Thanks
Ron