more than one combobox - accessing one table

[Guest]

I would like to have on a form a way to select from a table of lots of, say
fruit.
Today the user eats an apple, orange and a banana. If I had three combo
boxes reading the same table it carries the same info through all the users.

 

[Con Giacomini]

The way I see it, each fruit eaten should be a separate record. You should
use a main form to select the user, with a subform to enter all the fruit
records. Use a combo box in the subform with the fruit selection, select the
first fruit then go to the next new record to select the second fruit, etc.
Make sense?

Con Giacomini