Richard,
After watching Access 2010 Expert 1 video on Relational Combo Boxes I added a combo box using the combo box wizard.I selected the values from table option. I moved 2 fields over from the Available fields to the Selected fields side in the wizard.One field was the RoomTypeID the other was the RoomType. I chose hide the key column option. I stored that value in the RoomTypeID field.When I try to type a value that is not in the combo box list Access will not allow that. I went to design view and opened the property sheet for that combo box. I changed the LimitToList option to no. A pop up message states that "Microsoft Access can't set the LimitToList property to no right now. The first visible column which is determined by column width property isn't equal to the bound column. Adjust the column width property first then set the LimitToList property." I have adjusted the width and I the LimitToList property did change to no however when I changed to form view only a number appeared in the combo box not the text. Hope you can help.