Angela,

ComboBoxes don't work that way. You will only see the first visible column when the box is closed.

If you want to see the other fields on the form build a query that links your main table and the table that contains the data you want to display. Set the RecordSource equal to the query, add the combo and the extra fields to your form. When you update the ComboBox the related fields will also be updated.

Thank you Kevin - I'm a complete beginner - I've just gone through the beginner series so struggling a little I'll give it a try   I just want to be able to run a report / query which identifies batch numbers sold and to who if there's a product recall   but the key information in the order form entry is the item name  - so in the combo box I made 3 pieces of info available  item/batch number/best before date.     I figured Access would know all the info was there.... hopefully trying this means I can access it - pardon the pun  ;-)

The only way you can view multiple fields is to either concatenate them using a query and then all 3 will display inside the box when it's closed, OR you can use Dlookup and display them using an unbound form field. I actually have a Fast Tip video coming up on how to do this.

See this video: Multi Field Combo